RE: Sybase stored proc

2007-05-31 Thread O'Toole, Joe
to implement the solution Thanks -Original Message- From: O'Toole, Joe Sent: 30 May 2007 14:56 To: '[EMAIL PROTECTED]'; 'user-java@ibatis.apache.org' Subject: RE: Sybase stored proc Thanks for getting back. I should have pointed out in my previous mail that chan

RE: Sybase stored proc

2007-05-30 Thread O'Toole, Joe
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 30 May 2007 14:48 To: O'Toole, Joe; 'user-java@ibatis.apache.org' Subject: RE: Sybase stored proc There are a few solutions to your problem. One it to ensure that you have a transaction started before yo

RE: Sybase stored proc

2007-05-30 Thread Christopher . Mathrusse
Title: Sybase stored proc There are a few solutions to your problem. One it to ensure that you have a transaction started before you invoke the sp. All sp's have a default mode. The default is usually Unchained. If it is then it is required that the sp be executed within a transaction

Sybase stored proc

2007-05-30 Thread O'Toole, Joe
Hi I am calling a sybase stored proc and am getting the following error: Stored procedure may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode. I have seen the issue documented while going t