Hi Team, 

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 Team, 

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 Team, 

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 Hirst

Thanks Geoff
Well 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-56fdbbf57a41

Below is the procedure I am trying to run from Get collection stage  . It works perfectly fine while running from SQL developer

DECLARE vcEmpId VARCHAR2(6):= '506060'; vcAsOfDt VARCHAR2(10) := '2021-01-07'; nEmpTBHrs NUMBER := 0 ;nRtnCode NUMBER := 0;

BEGIN
tempus.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 

Thanks 

Hi Team, 

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 Hirst

Thanks Geoff
Well 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-56fdbbf57a41

Below is the procedure I am trying to run from Get collection stage  . It works perfectly fine while running from SQL developer

DECLARE vcEmpId VARCHAR2(6):= '506060'; vcAsOfDt VARCHAR2(10) := '2021-01-07'; nEmpTBHrs NUMBER := 0 ;nRtnCode NUMBER := 0;

BEGIN
tempus.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 

Thanks 

Hi Team, 

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?