Oracle REF Cursor

nikolayp — Thu, 21 Aug 2025 13:07:36 GMT

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

topic Oracle REF Cursor in Community Chat

Oracle REF Cursor