Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-01002: fetch out of sequence



ORA-01002: fetch out of sequence..

Answer / guest

Cause: This error means that a fetch has been attempted from
a cursor which is no longer valid. Note that a PL/SQL cursor
loop implicitly does fetches, and thus may also cause this
error. There are a number of possible causes for this error,
including: 1) Fetching from a cursor after the last row has
been retrieved and the ORA-1403 error returned. 2) If the
cursor has been opened with the FOR UPDATE clause, fetching
after a COMMIT has been issued will return the error. 3)
Rebinding any placeholders in the SQL statement, then
issuing a fetch before reexecuting the statement.

Action: 1) Do not issue a fetch statement after the last row
has been retrieved - there are no more rows to fetch. 2) Do
not issue a COMMIT inside a fetch loop for a cursor that has
been opened FOR UPDATE. 3) Reexecute the statement after
rebinding, then attempt to fetch again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16068: redo log file activation identifier mismatch

2 Answers  


ORA-32590: log group specification not allowed here

1 Answers  


ORA-25464: ROWID not specified for table alias: string

1 Answers  


QSM-00783: the specified value string contains an invalid date for parameter string

1 Answers  


ORA-00229: operation disallowed: already hold snapshot controlfile enqueue

1 Answers  






ORA-22991: insufficient space allocated for argument string

1 Answers  


RMAN-08025: channel string: copied controlfile copy

1 Answers  


ORA-01919: role 'string' does not exist

1 Answers  


LSX-00295: field element "~S" is not a simple type

1 Answers  


LPX-00203: could not read from "~s" (error ~u)

1 Answers  


PLS-00338: unable to resolve "string" as a column or row expression

1 Answers  


RMAN-08585: copying standby controlfile

1 Answers  






Categories