ORA-01002: fetch out of sequence
584983Sep 19 2007 — edited Sep 19 20071. One of the reason for getting ORA-01002: fetch out of sequence is to commit inside the cursor selected for update.
2. Also documentation says fetching from cursor after last row is retrieved also results in ORA-01002: fetch out of sequence.
Can anybody produce this error ORA-01002: fetch out of sequence in a small test case for reason 2 given above.