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 |
PCC-00070: Illegal syntax, Exponential value in SQL statement: string
ORA-06447: ssvpstp: Incorrect parameter passed to function call
NZE-28820: Signature or decryption/encryption state is not provided.
ORA-01651: unable to extend save undo segment by string for tablespace string
NID-00416: Change of database name failed.
ORA-31042: Too many properties in type 'string'
ORA-00325: archived log for thread string, wrong thread # string in header
TNS-00226: Unable to contact pump number to send broadcast message string
DRG-50603: unrecognized operation code string
ORA-07445: exception encountered: core dump [string] [string] [string] [string] [string] [string]
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
ORA-21779: duration not active