How to fix the Oracle error PLS-00413: identifier in CURRENT OF clause is not a cursor name?

In this post, you’ll learn more about the Oracle ErrorPLS-00413: identifier in CURRENT OF clause is not a cursor name with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00413: identifier in CURRENT OF clause is not a cursor name

Reason for the Error PLS-00413: identifier in CURRENT OF clause is not a cursor name

The identifier in a CURRENT OF clause names an object other than a cursor.

How to fix the Error PLS-00413: identifier in CURRENT OF clause is not a cursor name ?

You can fix this error in Oracle by following the below steps

Check the spelling of the identifier. Make sure that it names the cursor in the DELETE or UPDATE statement and that it names the cursor itself, not a FOR-loop variable.