Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Nested transactions?
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
![]() |
![]() |