How to fix the Oracle error PLS-00404: cursor ‘string’ must be declared with FOR UPDATE to use with CURRENT OF?

In this post, you’ll learn more about the Oracle ErrorPLS-00404: cursor ‘string’ must be declared with FOR UPDATE to use with CURRENT OF with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00404: cursor ‘string’ must be declared with FOR UPDATE to use with CURRENT OF

Reason for the Error PLS-00404: cursor ‘string’ must be declared with FOR UPDATE to use with CURRENT OF

The use of the CURRENT OF cursor_name clause is legal only if cursor_name was declared with a FOR UPDATE clause.

How to fix the Error PLS-00404: cursor ‘string’ must be declared with FOR UPDATE to use with CURRENT OF ?

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

Add a FOR UPDATE clause to the definition of the cursor or do not use the CURRENT OF cursor_name clause.