This solves a problem I was having some time ago while implementing
ecommerce (verisign):
1. insert customer's info
2. authorize credit card
3. log authorization response to database
4. if auth fails roll back #1, but keep #3
I was planning on solving this problem using Oracle's
AUTONOMOUS_TRANSACTION Pragma. I'll look into nested transactions and
see how these two differ.
Thanks,
Jay
On 9/7/06, Jonathan Vanasco <[EMAIL PROTECTED]> wrote:
take a look at:
http://search.cpan.org/~crakrjack/DBIx-Transaction-0.008/
which allows for nested transactions in a DBI handle.
