I get the following error when I connect to the Sybase database from my web-app. I put Set chained off in the procedure and nothing happenend. There seems to be a probelm in the Java Side.
com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'p_inter_status_dz' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.
Note: My Stored Procedure call is surrounded with a try/catch/finally, always closing the connection in the finally.