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.