On Wed, 2003-07-16 Michael wrote: >The default behavior of DBD::Sybase in AutoCommit OFF mode is to issue a >BEGIN TRAN before sending the first command. Therefore, because your >stored proc issues it's own BEGIN TRAN/COMMIT the complete transaction >will only finish when you run $dbh->commit() on that connection as you >have nested transactions and the whole thing can still be rolled back if >the outermost transaction is rolled back.
Well, I'm happy that I figured out what was going on... >You should investigate using the "chained" transaction mode (see the >syb_chained_txn attribute) as this is the native AutoCommit flag for >OpenClient. The dbh handle is in a utility module that can execute a number of sql statements. Since this is the only one that actually writes, I'll just put a check for AutoCommit == 0 and, if so, issue the commit myself. -------------------------------------------------------------------------- Matthew Persico Vice President Lazard 30 Rockefeller Plaza New York, NY 10020, USA Phone Number: 212.632.8255 Fax Number: 212.332.5904 Email: [EMAIL PROTECTED] ---------------------------------------------------------------------------
