Re: Nested Transactions

From: <michael_bialik_at_my-deja.com>
Date: Sun, 19 Sep 1999 13:43:23 GMT
Message-ID: <7s2p9q$n5o$1@nnrp1.deja.com>

You can do it with AUTONOMOUS TRANSACTIONS ( Oracle 8i).

Michael.

In article <37e3e55b.1745994_at_news1.ibm.net>, atadams_at_ibm.net (Andrew Adams) wrote:
> Is is possible to nest transactions with Oracle?
> I have a web app calling packaged procedures via MTS (Microsoft
> Transaction Server) To implement this, all commits and rollbacks are
> handled by MTS. The catch here is that I want to write and commit
> errors to a error table as they occur. Is it possible to wrap the
> error handling within a separate transaction so I can commit it
> without committing all the other work in progress?
> If this is not doable, what are my options other then logging to a
> file?
>
> Thanks in advance!
>
> Andrew Adams
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Sep 19 1999 - 08:43:23 CDT