Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-16409: Archive log switchover reference number mismatch

1 Answers  


NMP-00003: bad SNMP variable value

1 Answers  


ORA-14009: partition bound may not be specified for a LOCAL index partition

1 Answers  


ORA-25297: The message options only make sense for buffered messages

1 Answers  


ORA-29314: tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY

1 Answers  






RMAN-08026: channel string: copied archive log

1 Answers  


ORA-31093: null or invalid value specified for parameter : string

1 Answers  


TNS-04078: Unable to resume atleast one of the gateways.

1 Answers  


ORA-14407: partitioned table contains subpartitions in a different tablespace

1 Answers  


RMAN-08099: specifying standby controlfile for proxy backup

1 Answers  


ORA-15012: ASM file 'string' does not exist

1 Answers  


ORA-16028: new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires

1 Answers  






Categories