By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

under-transaction ?

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a

"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
Jul 19 '05 #2

P: n/a
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

Jul 19 '05 #3

P: n/a
CM
> This ng does not exist

Thank you to have answered me so quickly. Why this NG does not exist? ;-)
Christophe
Jul 19 '05 #4

P: n/a
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
Jul 19 '05 #5

P: n/a
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
Jul 19 '05 #6

P: n/a
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
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.