Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-06561: given statement is not supported by package DBMS_SQL

1 Answers  


ORA-16720: no available LOG_ARCHIVE_DEST_n parameters to use

1 Answers  


NNL-01041: Data stream open failures: number

1 Answers  


ORA-32617: missing MEASURES keyword in MODEL clause

1 Answers  


ORA-31603: object "string" of type string not found in schema "string"

1 Answers  


PCC-02359: Identifier specifying ARRAYLEN must be a 4-byte integer

1 Answers  


ORA-32831: timed out trying to acquire administration lock

1 Answers  


NNL-00981: Timeouts, server not responding: number

1 Answers  


ORA-30109: could not open parameter file 'string'

1 Answers  


ORA-33429: (EIFMAKEF17) CAUTION: NTEXT expression will be exported with type TEXT.

1 Answers  


ORA-38728: Cannot FLASHBACK DATABASE to the future.

1 Answers  


PCC-02366: Command line argument MODE=ANSI may not be used with DBMS=V6

1 Answers  


Categories