Using severals OUT parameters as cursors

[Alexx]

Good day,

I have a stored procedure that returns several cursors. Since TOracleDataSet allows to use one cursor, I can't use it, so I tried to use TOracleQuery. As per help, I defined second TOracleQuery to call SetComplexVariable. But there is no any possibility to use TDataSetProvider, because TOracleQuery is not a TOracleDataSet. Do you have any suggestions? Thanks in advance...

 

[Marco Kalter]

The TOracleDataSet only has one result set, so it can only fetch the results from one cursor. My first suggestion would be to split this in several procedures that all return one cursor.

------------------
Marco Kalter
Allround Automations