Re: under-transaction ?

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 20 Feb 2004 15:21:36 GMT
Message-ID: <4CpZb.22839$Xp.100897_at_attbi_s54>


"CM" <le-spam-je-dis-non_at_ulg.ac.be> wrote in message news:c157o9$k02_at_aix4.segi.ulg.ac.be...
> 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
>
>

Look up savepoint in the docs.
Jim Received on Fri Feb 20 2004 - 16:21:36 CET

Original text of this message