Re: ORA 1002 - fetch out of sequence problem in reports 2.5

or a bug in reports2.5 with long running queries

rtproffitt_at_my-deja.com wrote:

> There is a document on Fetch Out of Sequence
> Check out:
> http://technet.oracle.com/support/bboard/content/647.htm
>
> Summary:
> The cursor is no longer valid.
>
> Common Causes:
> Fetching after cursor returns no data.
> Example: an infinite loop with no exit:
> Open c1;
> loop fetch c1 into x; End Loop;
>
> Second Case:
> Selecting for Update, and while in the loop updating with a COMMIT.
> "commit across fetches in a select for update "
> The document explains the locking strategy and why this causes
> the error.
> "The solution to this problem is to move the commit
> outside the fetch loop or use a simple select rather
> than a select for update."
>
> Robert Proffitt
> Beckman Coulter
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 25 1999 - 00:03:37 CST