Knowledge Base > Automation Engine and Target Systems > Databases > Stored Procedures in Sybase

Stored Procedures in Sybase

The execution of stored procedures requires 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 is displayed 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."

The command "SET CHAINED OFF" cannot be called because of the JDBC driver. Use the command sp_procxmode instead.