In this blog post, you’ll learn more about the Sybase Error The option ‘%1’ cannot be set from within a procedure and the reason for receiving this error
Sybase SQL Error Message
The option ‘%1’ cannot be set from within a procedure
Reason for this Error
The option specified in the SET OPTION statement cannot be set from within a procedure.