Hi,
I look at the examples here https://github.com/dreamfactorysoftware/dsp-core/wiki/SQL-Stored-Procedures and it seems that you can return result sets over a procedure call.
The only way to get a recordset our of an Oracle procedure is to use a sys_refcursor as a return type. However the only options for declaring a return type of anout parameter seem to be basic primitive types.
Can we return result sets from Oracle as a result of a procedure call? And can you add the definitions of the procedures in the documentation link above so we can understand the underlying database procedures? That would be very helpful.
Many thanks
Stephen