Sybase Error – FOR UPDATE or FOR READ ONLY clause must be specified on PREPARE (not on DECLARE CURSOR)

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.