Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Nested transactions?

Nested transactions?

From: Mr. Jeremy Bettis <bettis_at_inetnebr.com>
Date: 1996/12/24
Message-ID: <59otbf$8qv@falcon.inetnebr.com>#1/1

Does Oracle have nested transactions? i.e. can I do something like this:

start transaction

insert foo...

start transaction

insert bar...

rollback

insert baz...

commit

and have foo and baz done, but not bar ? Other databases have this, yet I can't see how to do it here. I am using OCI to access the database. But an example in PL/SQL would be fine too.
. Received on Tue Dec 24 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US