'Fetch Out of Sequence'?
From: Paul Swallow <113220.3573_at_CompuServe.COM>
Date: 1998/04/02
Message-ID: <#efuP0lX9GA.352_at_nih2naaa.prod2.compuserve.com>#1/1
Date: 1998/04/02
Message-ID: <#efuP0lX9GA.352_at_nih2naaa.prod2.compuserve.com>#1/1
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; -- ------- -------- -------Received on Thu Apr 02 1998 - 00:00:00 CEST
------- -------- -------
------- -------- -------
------- -------- -------