Page 1 of 1

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

Posted: Tue 28 Dec 2004 16:28
by Pavel
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.

Posted: Thu 30 Dec 2004 13:05
by Alex
We reproduced your problem and fixed it. This fix will be included in the next ODAC build.