Devart Forums

Hi all

I'm calling a Oracle 10g stored procedure which returns three cursors as return parameters.

I'm using the dbexpress TSQLStoredProc object in Delphi 7 (Build 8.1) to do this task. There's no problem with the first cursor but when i try to get the second one (using NextRecordSet method) Delphi raises an "Cursor not returned from Query" exception.

Is it possible to fetch multiples recordsets from TSQLStoredProc using the dbExpress driver for Oracle Standard version 3.10.6 (11.10.06) (it's the one i'm using).

Thanks in advance.

Currently the NextRecordSet method of TSQLStoredProc is not supported by the Core Lab dbExpress driver for Oracle. We'll consider possibility to implement this feature in either of the next DbxOda builds.