This content has been marked as final.
Show 2 replies
-
1. Re: Getting The 'SET CHAINED OFF' command error
duslow Sep 28, 2004 1:14 PM (in response to syedahmed)You need to make sure your Sybase stored procedure is set to "Any" mode.
For example: EXEC sp_procxmode '<your_proc_name>','anymode'
This will allow the transaction for the stored procedure to be controlled by external clients (ie the JBoss container). It will also work with local clients as well, thus the "Any" mode.
Hope that helps,
Dustin -
2. Re: Getting The 'SET CHAINED OFF' command error
syedahmed Sep 30, 2004 4:45 AM (in response to syedahmed)thanks