473,320 Members | 1,902 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
Jul 19 '05 #1
6 1831

"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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

18
by: Adrian B. | last post by:
Does anyone know of a framework or library that will enable me to use publish/subscribe comms? I want to create a server (using Python) running on a Unix box that will accept client connections...
1
by: dumblede | last post by:
Hello fellows, i would like to center a 800px wide 600px high content area without using frames. I have "come up" with the following solution so far. It works under IE 6.0, Firefox 1 (under...
1
by: VNG | last post by:
I have an ANSI C program that was compiled under Windows MSVC++ 6.0 (SP6) and under Linux gnu, and ran under P3, P4 and AMD. It runs fine on P3 and AMD under both Windows and Linux, but under P4...
5
by: Andrew Poulos | last post by:
The web pages that I've been building under Windows and which validate and display without error or problem with IE, MZ and FF are problematic under Linux - Fedora Core 3. I have a 512K ADSL...
3
by: Christopher | last post by:
One of our ASP.NET Pages is starting a new Process using the Process object. When the process starts, it is started under the ASPNET User. We tried editing the web.config file and the...
5
by: cdlipfert | last post by:
Our intranet is running under windows integrated security. We have domain users that want to access our intranet site via ssl vpn. SSL VPN can not authenticate against services that run under...
6
by: Adam | last post by:
On an xp machine, the caching works as expected. I have deployed to a win2k server, and an item I add to the cache expires almost immediately some times and in under a minute in other times. The...
3
by: Philip Wagenaar | last post by:
Framework 1.1 I want to start AcrobatReader to print a printjob under a specific username (so that the owner of the printjob is not the username of the application that the .net application runs...
0
by: Tom | last post by:
I am not sure if this should be under the SourceSafe or the VB.NET forum, so I will post to both and hope someone has the answer: I have a VB.NET project stored under SourceSafe - Let's say the...
5
by: rogersw8n | last post by:
Some how, some way the account that creates folders under Temporary Internet files has been changed to a domain account for VS 2003 and VS 2005. I recently installed VS 2005. All seemed to be ok...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.