Re: Oracle "Fetch out of Sequence Error"

From: Bert Scalzo <bscalz01_at_7-11.com>
Date: 1998/03/10
Message-ID: <6e43ki$mlq$1@news.ses.cio.eds.com>#1/1

Often this happens (the oracle error that is) when one has a cursor opened and does commits while skipping though the records. For example, the cussor does a select for update (one of the PB locking modes) and then does a commit, and then tries to resume reading through additional records in the cursor.

Joe Whalley wrote in message <35041B13.E4C88FB6_at_mitre.org>...
>On a datawindow that accesses a particular Oracle table, I randomly
>get the Oracle "Fetch out of Sequence Error". It does not happen all of
>the time, but it only happens on this dw. What causes this and how can I
>get rid of it? Using PB 5.02 on Win95 and Oracle 7.3.2.3.1 on NT.
>Thanks
>Joe
Received on Tue Mar 10 1998 - 00:00:00 CST