How to fix the Oracle error PCB-00555: Using WHERE CURRENT OF on cursor defined without FOR UPDATE clause?

In this post, you’ll learn more about the Oracle ErrorPCB-00555: Using WHERE CURRENT OF on cursor defined without FOR UPDATE clause with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCB-00555: Using WHERE CURRENT OF on cursor defined without FOR UPDATE clause

Reason for the Error PCB-00555: Using WHERE CURRENT OF on cursor defined without FOR UPDATE clause

Cause: if mode=ORACLE, then a cursor defined with a WHERE CURRENT OF clause must also have a FOR UPDATE clause.

How to fix the Error PCB-00555: Using WHERE CURRENT OF on cursor defined without FOR UPDATE clause ?

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

Action: Rewrite the cursor definition.