Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-34656 – (MXSQL24) Additional WHERE clause conditions with CURRENT OF <cursor name> syntax

Oracle Database Error Code ORA-34656 Description :

(MXSQL24) Additional WHERE clause conditions with CURRENT OF syntax

Error Cause:

A SQL UPDATE or DELETE statement tried to use the CURRENT of syntax with a WHERE clause containing multiple conditions.

How to Solve :

When using the CURRENT OF syntax make sure it is the only condition in the WHERE clause.