| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> why 1002-fetch out of sequence?
Hello All.
Why in IF block commit make error:
ORA-01002: fetch out of sequence
DECLARE
err number;
CURSOR NS1 IS SELECT PRIM FROM NS where ndet like '21%' FOR UPDATE
OF PRIM;
NS_RECORD NS1%ROWTYPE;
update NS set PRIM = PRIM WHERE CURRENT OF NS1;
IF MOD(ns1%rowcount,100) = 0 THEN
COMMIT WORK; /* it is HERE*/
END IF;
END LOOP;
![]() |
![]() |