Stored Procedures in Sybase

To execute stored procedures, you must use an additional command.

Use the following lines to call a stored procedure:

execute sp_procxmode 'procedure name','anymode';
execute procedure name;

The following error message appears if an attempt is made to execute a stored procedure directly:

Stored procedure 'procedure name' can be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.

Do not use the SET CHAINED OFF command because it cannot be used with the JDBC driver. Use the sp_procxmode command instead.