2 weeks ago - last edited 2 weeks ago
Hi,
After the July update, it was announced that there is now support REF Cursor output parameter in storage procedure.
When I tried to test this I get the error : "
OPA error: Error : 6550, Position : 6, Sql = BEGIN apps.NIKO_TEST_REF.get_invoices("INVOICEID" => :1 , "PINVOICES" => :2 ); END;, Original Sql = {call apps.NIKO_TEST_REF.get_invoices("INVOICEID" => ?, "PINVOICES" => ?)}, Error Msg = ORA-06550: line 1, column 7:PLS-00306: wrong number or types of arguments in call to 'GET_INVOICES'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored"
And structure of out parameter is not built correctly , Field of ref cursor on the same level ref cursor, and in ref cursor I have only index and size. It is clear from the error INVOICEID is it field of REF CURSOR PINVOICES.
Workato in very strange way build the output paramter.
Any idea , what is wrong ?
Thanks