under-transaction ?

[CM]

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

[Jim Kennedy]

"CM" <le****************@ulg.ac.be> wrote in message
news:c1********@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

[Frank van Bortel]

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

[CM]

> This ng does not exist

Thank you to have answered me so quickly. Why this NG does not exist? ;-)
Christophe

[CM]

> Look up savepoint in the docs.

Jim

thank you very much. It's perfect !
While hoping to be able to return the similar one to you
Christophe

[Hans Forbrich]

CM wrote:

This ng does not exist

Thank you to have answered me so quickly. Why this NG does not exist? ;-)
Christophe

In 1997 the attendees votes to replace this comp.database.oracle (c.d.o)
newsgroup with a set of newsgroups - c.d.o.server, c.d.o.tools,
c.d.o.marketplace and c.d.o.misc As a result, some ISPs do not carry
c.d.o but do carry the lower ones, and you run the risk of not getting
the visibility you want.

When we remember, we try to discourage using this one.

/Hans

[CM]

> In 1997 the attendees votes to replace this comp.database.oracle (c.d.o)

newsgroup with a set of newsgroups - c.d.o.server, c.d.o.tools,
c.d.o.marketplace and c.d.o.misc As a result, some ISPs do not carry
c.d.o but do carry the lower ones, and you run the risk of not getting
the visibility you want.

When we remember, we try to discourage using this one.

/Hans

I understand. Thank you for this information.
Better regards.
Christophe