under-transaction ?

#1

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

#2

CM
I have 8 years in Oracle and have never needed this
What you would like to do ?
INSERTs take time. I would analyze data before doing it or use EXCEPTION for
something extraordinary

"CM" <le-spam-je-dis-non (AT) ulg (DOT) ac.be> wrote

Quote:

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

#3

Quote:

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)

Read about SAVEPOINT

Hilarion

#4

CM wrote:

Quote:

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

Read about autonomous transactions. They might be what you need.

#5

In addition to what others have posted, you might want to read up on
AUTONOMOUS TRANSACTIONS.

--
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

"CM" <le-spam-je-dis-non (AT) ulg (DOT) ac.be> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

under-transaction ?

comp.database.oracle comp.database.oracle

under-transaction ? - 02-20-2004 , 09:05 AM

Re: under-transaction ? - 02-20-2004 , 11:10 PM

Re: under-transaction ? - 02-23-2004 , 02:41 AM

Re: under-transaction ? - 02-23-2004 , 06:04 AM

Re: under-transaction ? - 03-01-2004 , 01:39 PM