I am trying to call an Oracle stored procedure that has a ref cursor as an output parameter in OPA. I cannot get it to work. In the list of base-types for output parameters none of them seem suitable.
I know that you can return an open cursor as a result set but can’t find any examples of actually returning one as an output parameter. Is this actually possible in OPA?
Hi,
For Ref Cursors, OPA has a few base-types for output parameters depending on what the stored procedure outputs. I would recommend trying to use the Text, multi-line formatted option if the cursor outputs a structured text format like a JSON string, XML or any other structured data output. Alternatively you could try using the File option if the ref cursor result is exported as a file you can download, i.e CSV or a JSON file.
Let me know if this helps.
