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.