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

RMAN-06179: datafile number not processed because file is read-only

1 Answers  


SQL*Loader-00628: Character set conversion error.

1 Answers  


ORA-01497: illegal option for ANALYZE CLUSTER

1 Answers  


NZE-29151: 3DES self-test failure

1 Answers  


LSX-00251: invalid token "~S"

1 Answers  






TNS-12682: Login failed: the SecurID card is in next PRN mode

1 Answers  


ORA-02739: osncon: host alias is too long

1 Answers  


ORA-15010: name is already used by an existing ASM disk

1 Answers  


ORA-02048: attempt to begin distributed transaction without logging on

1 Answers  


ORA-19695: fixed table x$krbmsft has not been populated

1 Answers  


NZE-29193: no CRL found using CRLDP mechanism

1 Answers  


QSM-00763: the owner string is invalid while validating user-defined workload string.string

1 Answers  


Categories