I have a stored procedure, where I am trying to execute by using “Call” in “Execute Query” Activity and passing the required input. The return type of the procedure id “Refcursor Recordset”. Iam using the following commands to execute it:
VAR vcur refcursor;
TYPE Recordset IS REF CURSOR;
-> when I run the above command from uipath I am getting error like “Execute Query 1: ERROR  [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement”.
but when I tried running the same from sql management application, I am able to get the output.
-> when I tried declaring the return type locally, it is showing error like below screenshot
Can anyone please tell me is there any way or limitations in UiPath to execute the stored procedure with return type as “ref cursor recordset”