Can´t fetch multiples RecordSets from TSQLStoredProc

nak · Post by **nak** » Thu 14 Dec 2006 15:03

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.

Plash · Post by **Plash** » Fri 15 Dec 2006 16:09

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.