Cursor variable cannot be nil - mutliple cursor outputs

[nbstrat]

I am attempting to call a stored procedure that returns two SYS_REFCURSORS but I always get the error Cursor variable cannot be nil.

I can call the procedure via my SQL editor and verify that both cursors have results.

begin
my_package.my_procedurep_cursor_1, _cursor_2);
end;

Within the OracleDataSet, I have both of the variables defined as type Cursor. Procedure calls that return a single SYS_REFCURSOR work fine. Do I need to be doing something different when returning two SYS_REFCURSOR's?

 

[Marco Kalter]

The TOracleDataSet does not support multiple result sets, so it can only process 1 cursor variable. You will need to use a TOracleQuery to process 2 cursor variables from a single procedure call.