Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL: cascaded transactions?
ORACLE doesn't support nested transactions.
Eckart Schultz wrote:
>
> is it possible (Oracle 7.3 or higher) to make cascaded transactions like the
> following:
>
> set transaction -- global trans
> update ...
> loop
> set transaction -- local trans
> insert ...
> commit or rollback -- local trans
> end loop
> commit or rollback -- global trans
>
> if the global transaction will rollback it will rollback all commited local
> transactions too. if not possible, what I have to do to have the same
> effect?
>
> Thanks for any ideas
> Eckart
Received on Tue May 18 1999 - 16:21:02 CDT
![]() |
![]() |