Home » SQL & PL/SQL » SQL & PL/SQL » oracle Error
oracle Error [message #35611] Mon, 01 October 2001 07:13 Go to next message
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 Go to previous message
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.

----------------------------------------------------------------------
Previous Topic: privileges on Packages.
Next Topic: Re: Please help on an insert
Goto Forum:
  


Current Time: Sat May 25 09:25:26 CDT 2024