Oracle Solution for Error ora-35578

Solution for Oracle Error ORA-35578

ORA-35578: (SQLOUT11) SQL cursor 'number

' cannot be used with CURRENT OF syntax

What triggered the Error:

The CURRENT OF syntax in the WHERE clause tried to use a cursor that was not declared with the FOR UPDATE [ of ] SQL syntax.

What should we do to fix it:

Add the FOR UPDATE [ OF ] SQL syntax to the cursor specified.

If this was not sufficient go over to: Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board

Copyright 2020. All Rights Reserved