Re: Fetch out of sequence - server 7.3.2

Dave Wotton wrote:
>
> Kenneth C Stahl wrote in message <3923E170.6836C80B_at_Unforgettable.com>...
> >Delphis Group Limited wrote:
> >>
> >> Hi
> >> On running a specific report on a client site a -1002 fetch out of
> >> sequence is generated.
> >>
> >> Does anyone have any experience of this?
> >
> >This occurs in two different scenarios:
> >
> >1. when an application attempts to perform a FETCH against a cursor that
> >has not been opened.
> >
> >2. When an application attempts to perform a FETCH against a cursor that
> >has returned 1403 from the last fetch. Keep in mind that 1403 (No data
> >found) is not an error because it is a positive value instead of a
> >negative one. It is not an error to retrieve the last row of a cursor -
> >however, it is an error to perform additional fetches once 1403 has been
> >returned.
>
> or in a third situation when you attempt to retrieve a row from a FOR
> UPDATE cursor after you have issued a commit. This example is in the
> Oracle documentation:
>

I guess I've never run into that one because I consider it to be dangerous and therefore have never coded it. Received on Fri May 19 2000 - 00:00:00 CDT