Behavior change declaring variables in procedures [CR 584334]

In Sybase IQ 12.7 and later releases, new procedures are invalid when there are duplicate declarations of a variable within a compound statement. This error is reported:

There is already a variable named '@variable_name'
SQLCODE=-261, ODBC 3 State="42000"

Ensure there is only a single instance of a variable in a compound block.