SybSQLException: Stored procedure 'xxx be run only in un chained mode
srinivas nama
Greenhorn
Joined: Aug 20, 2001
Posts: 3
posted
0
com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'ap_SystemAccess' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode. I am trying to execute procedure, //cs.executeUpdate("SET CHAINED OFF"); // String sptest = " { call sp_procxmode ccsys.dbo.ap_SystemAccess" + "," + " anymode }" ;
boolean rc1 = cs.execute(); con.commit(); con.setAutoCommit(true); It is giving me above error, then I tried to run sp_proxmode anymode, it is giving syntax error near '.'[ccsys.dbo.ap_SystemAccess] any help appreciated, Thanks, Srini