| Re: ORA-01002: fetch out of sequence [message #375020] |
Thu, 19 July 2001 04:34 |
kavithask
Messages: 34
Registered: March 2001
Location: London
|
Member |
|
|
Hi,
The following are the notes from OTN.
ORA-01002 fetch out of sequence
Cause: 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.
Action: Parse and execute a SQL statement before attempting to fetch the data.
**************
Just check if you have issued a commit after the cursor has been parsed which looks at the same data."This may be caused by fetching from a SELECT FOR UPDATE cursor after a commit."
HTH
Kavitha
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
