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;