Stored Procedure Executed in Unchained Transaction Mode

This error occurs when JDBC attempts to send the connection in autocommit(true) mode.

Sybase Error 7713 - Stored Procedure can only be executed in unchained transaction mode.

The application can change the connection to chained mode using Connection.setAutoCommit(false) or by using a “set chained on” language command. This error occurs if the stored procedure was not created in a compatible mode.

To fix the problem, use:

sp_procxmode procedure_name,"anymode"