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

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL: cascaded transactions?

Re: PL/SQL: cascaded transactions?

From: Jay Walters <jwalters_at_computer.org>
Date: Tue, 18 May 1999 17:21:02 -0400
Message-ID: <3741D9BE.5429FCE@computer.org>


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

Original text of this message

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