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 |
DRG-11531: start token not found on line string
QSM-01003: no query rewrite on DDL queries
PLS-00166: bad format for date, time or timestamp literal
ORA-07759: slemtr: invalid destination
ORA-19697: standby controlfile not found in backup set
CLSR-00510: Unable to load NLS data
TNS-12234: TNS:Redirect to destination
ORA-01116: error in opening database file string
ORA-28044: unsupported directory type
ORA-04010: the number of values to CACHE must be greater than 1
ORA-07713: sksamtd: could not mount archival device (SYS$MOUNT failure)
KUP-03001: fatal error during library cache pre-loading