In this post, you’ll learn more about the Oracle ErrorPCC-02450: Cursor was not declared in scrollable mode with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PCC-02450: Cursor was not declared in scrollable mode
Reason for the Error PCC-02450: Cursor was not declared in scrollable mode
Cause: A cursor which was not DECLAREd in SCROLL mode was used in scrollable mode in the FETCH statement.
How to fix the Error PCC-02450: Cursor was not declared in scrollable mode ?
You can fix this error in Oracle by following the below steps
Action: Declare the cursor in scroll mode using the SCROLL keyword.