"FOR UPDATE or FOR READ ONLY clause must be specified on PREPARE (not on DECLARE CURSOR)"
| Item |
Description |
|
SQLCode
|
-1290L
|
|
Constant
|
CURSOR_UPDATABILITY_CHANGED
|
|
SQLState
|
42WD4
|
|
ODBC 2 State
|
S1009
|
|
ODBC 3 State
|
HY092
|
|
Sybase Error Code
|
2978
|
|
Severity Code
|
16
|
Probable cause
You specified the FOR UPDATE or FOR READ ONLY clause on a DECLARE CURSOR statement. The FOR UPDATE or FOR READ ONLY clause must be specified on the PREPARE statement and not the DECLARE CURSOR statement.