| oracle Error [message #35611] |
Mon, 01 October 2001 07:13  |
V
Messages: 12
Registered: October 2001
|
Junior Member |
|
|
Iam getting this error when i try to select from the
database, its embedded select statement
Err: -1002 STR: ORA-01002
----------------------------------------------------------------------
|
|
|
|
| Re: oracle Error [message #35612 is a reply to message #35611] |
Mon, 01 October 2001 07:33  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
Oracle documentation says:
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.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
