How to fix the Oracle error PCC-02342: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause?

In this post, you’ll learn more about the Oracle ErrorPCC-02342: 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

PCC-02342: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause

Reason for the Error PCC-02342: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause

Cause: When MODE=Oracle, a cursor defined with a WHERE CURRENT OF clause must also have a FOR UPDATE clause.

How to fix the Error PCC-02342: 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.