SQL-02118: Invalid row for a WHERE CURRENT OF operation



SQL-02118: Invalid row for a WHERE CURRENT OF operation..

Answer / guest

Cause: An attempt was made to reference a nonexistent row
using the CURRENT OF clause in an UPDATE or DELETE
statement. This happens when no FETCH has been executed or
when FETCH returns a "no data found" error that the program
fails to trap.

Action: Check that the last cursor operation succeeded and
that the current row of the cursor is valid. The outcome of
a cursor operation can be checked in two ways: implicit
checking with the WHENEVER statement or explicit checking of
SQLCODE in the SQLCA.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07455: estimated execution time (string secs), exceeds limit (string secs)

1 Answers  


QSM-02146: see the reason why REFRESH_FAST_AFTER_INSERT is disabled

1 Answers  


ORA-33048: (XSAGDNGL23) In AGGMAP workspace object, the relation workspace object and the relation workspace object are both over the same base dimension.

1 Answers  


ORA-24019: identifier for string too long, should not be greater than string characters

1 Answers  


SQL*Loader-00506: formatting error reading SDF or LOBFILE string for column string in table string

1 Answers  






ORA-31528: could not find change set string for CDC subscription string

1 Answers  


ORA-34296: (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).

1 Answers  


KUP-04014: invalid SLF parameter

1 Answers  


ORA-09340: Specified ORACLE_SID is either invalid or too long

1 Answers  


ORA-36883: (XSSRF02) The first parameter of an AW single row function cannot be NULL.

1 Answers  


ORA-08401: invalid compiler name: string

1 Answers  


ORA-12070: cannot offline instantiate materialized view "string"."string"

1 Answers  


Categories