Re: PL/SQL: cascaded transactions?

I don't think so.
Oracle considers a complet PL/SQL block as 1 SQL statement. So automaticaly it's all in the same transaction.

Gert

Eckart Schultz <es_at_dcs.de> wrote in article <7hrrjj$61h$1_at_unlisys.unlisys.net>...
> 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 - 15:45:19 CDT