In this blog post, you’ll learn more about the Sybase Error FOR UPDATE or FOR READ ONLY clause must be specified on PREPARE (not on DECLARE CURSOR) and the reason for receiving this error
Sybase SQL Error Message
FOR UPDATE or FOR READ ONLY clause must be specified on PREPARE (not on DECLARE CURSOR)
Reason for this Error
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.
