Re: under-transaction ?

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 20 Feb 2004 16:25:56 +0100
Message-ID: <c158rh$6mk$1_at_news1.tilbu1.nb.home.nl>


CM wrote:

> Hello,
>
> Is it possible to create a transaction in a transaction?
>
> BEGIN T1
>
> INSERT into t1 values(2);
>
> BEGIN T2
>
> INSERT into t1 values(3);
>
> ROLLBACK T2
>
> COMMIT T1
>
> I will have liked that the "ROLLBACK" of the T2 transaction
> does not disturb the "INSERT" made in the principal transaction.
> If that exists, which are commands SQL for Oracle 9i? Thank you very much.
> (And excuse me for my imperfect English)
>
> Christophe
>
>
This (oracle) is NOT sql server.

And yes - using autonomous transactions it would be possible. And... if you want this for logging purposes, look at the monitor sub command of the alter table SQL command. The SQL Reference Guide can be found online at http://docs.oracle.com

And last but not least - this should have been posted in c.d.o.database. This ng does not exist

-- 

Regards,
Frank van Bortel
Received on Fri Feb 20 2004 - 16:25:56 CET

Original text of this message