Re: Is it possible to nest transactions?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Fri, 05 Mar 1999 17:20:34 +0800
Message-ID: <36DFA1E2.1CA4@bhp.com.au>

Csaba Toth wrote:
>
> Hi all,
>
> Coming from a Sybase (SQLA) background, I would like to know, whether it
> is possible to nest transactions. Also, is there a command you can
> issue to explicitly tell Oracle you want to start a transaction? (Sort
> of like in SQLA "BEGIN TRANSACTION")
> If nested transactions are possible, does Oracle keep a variable of some
> sort (one that you can hopefully query) on the transaction nesting
> depth?
>
> I am searching the doco, but no mention of nested transactions.
>
> While I am at it, is there an engine option you can set to tell Oracle
> to AUTOCOMMIT after DML statements?
>
> Any help is much appreciated.
>
> Regards
>
> Csaba Toth
>
> --
> Csaba Toth
> Programmer [Development]
> csaba_at_addease.com.au
>
> Addease Pty. Ltd.
> P.O. Box 1484
> COLLINGWOOD VIC 3066
> Australia
>
> Ph : +61 3 9416 2944
> Fax: +61 3 9416 2580
> web: http://www.addease.com.au

Have a read on SAVEPOINT and ROLLBACK TO SAVEPOINT for versions 7 and 8.0..

In 8.1 you can do autonomous transactions..

HTH
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Fri Mar 05 1999 - 03:20:34 CST