|
Ummm that doesn't work like you think it does... AutoCommit => 0 just makes it so that each statement doesn't commit itself. Mainly for use in batching and speedups.
From the DBI manpage:
"The transaction behaviour of the "disconnect" method is, sadly,
undefined. Some database systems (such as Oracle and Ingres) will
automatically commit any outstanding changes, but others (such as
Informix) will rollback any outstanding changes. Applications not
using "AutoCommit" should explicitly call "commit" or "rollback"
before calling "disconnect"."
Even with AutoCommit=>0 a database handle disconnect of any kind commits any non-rolled-back statements in Oracle.... which is what I am trying to avoid :P
I will check out the other list for help also... thanks!
|
(14)
]
