Until your execute() or do() the statement hasn't occurred yet, so there's nothing to commit or rollback.
Each time you commit or rollback, a new transaction starts. Transactions are session specific, so the transactions in two open database handles in the same program are independent of each other. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.htm Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 14:03 Subject: Oracle DBI commit/rollback question... > Does anybody know how Oracle8i handles transactions from DML statements > passed from a DBI database connection? > > Do the dbh->commit() and dbh->rollback() statements commit or rollback > all DML instructions issued while the connection is open, or just those > which get passed by sth->do() or sth->execute()?