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

Oracle Error Message

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

Reason for the Error

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

Solution

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