Can´t fetch multiples RecordSets from TSQLStoredProc

Can´t fetch multiples RecordSets from TSQLStoredProc

Postby 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.
Posts: 1
Joined: Thu 14 Dec 2006 14:17

Postby 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.
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Return to dbExpress driver for Oracle