I am trying to call a procedure in Oracle after establishing connection through Oracle MDA utility but no luck yet. I can run normal SQL queries and get desired result.
Any pointers anyone?
Hi @Geoff HirstThanks GeoffWell my company uses blue prism version 6 and while using this tool., Eric made a custom code which suits version 6. Below is the link to the previous discussion I had https://community.blueprism.com/communities/community-home/digestviewer/viewthread?MessageKey=f3e6a94b-7602-4101-8520-adc40759c969&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=digestviewer#bm1556d6e7-92e0-41d7-9523-56fdbbf57a41Below is the procedure I am trying to run from Get collection stage . It works perfectly fine while running from SQL developerDECLARE vcEmpId VARCHAR2(6):= '506060'; vcAsOfDt VARCHAR2(10) := '2021-01-07'; nEmpTBHrs NUMBER := 0 ;nRtnCode NUMBER := 0;BEGINtempus.tempus_schedule2.GetTBRelativeToShiftAsOfDate (vcEmpId,vcAsOfDt,nEmpTBHrs,nRtnCode);dbms_output.put_line('nEmpTBHrs: '||to_char(nEmpTBHrs));dbms_output.put_line('nRtnCode: '||to_char(nRtnCode));END;Here the inputs are vcEmpId and vcAsOfDt
and the outputs are nEmpTBHrs,nRtnCode.
While executing this code as given above It gibes the below error
ORA-06550: line 1, column 400:PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:; <an identifier> <a double-quoted delimited-identifier>The symbol ";" was substituted for "end-of-file" to continue.Do I need to change some syntax in the procedure? Please let me know
Hi @Geoff Hirst
I was able to solve this. I made a separate code stage which included some tweaking of the C# code as given in below link.net - Calling Oracle stored procedure from C#? - Stack OverflowThanks
NEW TO RPA?
What is Intelligent Automation?
Blue Prism Product Suite
Way Beyond RPA
Contact the Community Team
Blue Prism DX
Blue Prism University
Privacy & Cookies
Terms of Service
© Blue Prism