take a look at:
http://search.cpan.org/~crakrjack/DBIx-Transaction-0.008/
which allows for nested transactions in a DBI handle.
I use something homegrown and similar (but not stable enough for
cpan), that intercepts calls to connect/disconnect and treats them as
begin/end commands on a nested transaction
note that either solution aren't true db style nested transactions ( i think only pg and oracle have them anyways ). they just intercept begin/end if you're already in a transaction.
