Bruce Johnson wrote: > If $dbh is my database handle, to roll back the current transaction I > do: $dbh->rollback(); right? > > The DBD::Oracle docs don't explicitly say.... > >
You want to look at the DBI pod. The begin_work method starts a txn and the commit and rollback methods commit or rollback a txn. In general DBDs don't repeat all documentation from DBI but list the exceptions or deviations from the DBI spec. You might also want to look at the AutoCommit attribute on a connection handle and also specifiable on the connect method. So to answer your question, yes the rollback method rolls back your txn but you need to call begin_work first unless you disabled AutoCommit in which case you will need to commit everything you do (and that can include even selects in some DBDs). Martin
