ORA-01002: fetch out of sequence in non-blocking mode

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Pavel
Posts: 1
Joined: Tue 28 Dec 2004 14:55

ORA-01002: fetch out of sequence in non-blocking mode

Post by Pavel » Tue 28 Dec 2004 16:28

Sequential attempts of dataset reopening via close/open calls in Non-blocking mode lead to error ORA-01002 fetch out of sequence.

You can replicate this by creating a project with master/detail datasets.
The detail dataset should have enough records to allow moving between master records during loading of previous detail records by detail dataset.

P.S. We implemented master-detail by creating OnAfterScrool handler which binds the parent-child variables and reopens the detail dataset.

Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Thu 30 Dec 2004 13:05

We reproduced your problem and fixed it. This fix will be included in the next ODAC build.

Post Reply