Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Nested transactions?
Hi Jeremy,
I don't think oracle directly supports this (nested trans).
However, you can create 2 separate database connections in your oci program
and rollback just one of them.
Hope that helps,
Gert
-- At Home: gem_at_wirehub.nl At Work: gert.rijs_at_corp.ah.nl Mr. Jeremy Bettis <bettis_at_inetnebr.com> wrote in article <59otbf$8qv_at_falcon.inetnebr.com>...Received on Tue Dec 24 1996 - 00:00:00 CST
> 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.
> .
>
>