-228 FOR UPDATE CLAUSE SPECIFIED FOR READ-ONLY CURSOR cursor-name
Explanation
A cursor was declared read-only with the INSENSITIVE
SCROLL option, but the SELECT statement contained a FOR UPDATE clause.
- cursor-name
- Name of the cursor used for the FETCH.
System action
The statement cannot be processed.
Programmer response
To define a scrollable cursor that is read-only, specify INSENSITIVE SCROLL, but do not specify FOR UPDATE clause. To define a scrollable cursor that can be updated, specify SENSITIVE SCROLL. Correct the application program to DECLARE CURSOR appropriately.
SQLSTATE
42620