Can´t fetch multiples RecordSets from TSQLStoredProc

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
Posts: 1
Joined: Thu 14 Dec 2006 14:17

Can´t fetch multiples RecordSets from TSQLStoredProc

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.

Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

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.

Post Reply