Return records via Oracle Procedure (SYS_REFCURSOR)


#1

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


#2

Any ideas? If I can’t return recordsets via Oracle, I can’t use DreamFactory. The only way to return a recordset from Oracle is using a cursor as an out parameter.