ORA-01002

Error: ORA-01002: fetch out of sequence

Causa: In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This can occur if an attempt was made to FETCH from an active set after all records have been fetched. This may be caused by fetching from a SELECT FOR UPDATE cursor after a commit. A PL/SQL cursor loop implicitly does fetches and may also cause this error.

Acción: Parse and execute a SQL statement before attempting to fetch the data.

COMENTARIOS:

por FredJ | 18/04/2007 21:11:39

RE: ORA-01002

Connection.setAutoCommit(false);