Re: 'Fetch Out of Sequence'?

From: Keith Boulton <boulkenospam_at_globalnet.co.uk>
Date: 1998/04/05
Message-ID: <35274299.685014@read.news.global.net.uk>#1/1

On Thu, 02 Apr 1998 12:30:40 -0500, Paul Swallow <113220.3573_at_CompuServe.COM> wrote:

>Does anyone agree that the following nested loop should not
>produce a 'fetch-out-of-sequence' error when tables paul2 & paul3
>each have 2 rows 'Committed'? Unfortunately this error does
>occur!
>
>
>OPEN cur1;
>LOOP <<LOOP1>>
> FETCH cur1 INTO var1;
> EXIT WHEN cur1%NOTFOUND;
> OPEN cur2;
> LOOP <<LOOP2>>
> FETCH cur2 INTO var2;
> EXIT WHEN cur2%NOTFOUND;
> INSERT INTO PAUL VALUES('X');
> ROLLBACK;
> END LOOP LOOP2;
> CLOSE cur2;
>END LOOP LOOP1;
> CLOSE cur1;
>
>
>

I should have said, I think it also depends on an init.ora parameter, (close_open_cursors?) Received on Sun Apr 05 1998 - 00:00:00 CST