Re: PL/SQL: cascaded transactions?

From: Luis Morales Boisset <lboisset_at_infonis.es>
Date: Wed, 19 May 1999 21:40:50 +0200
Message-ID: <7hv3qc$2ru$1@diana.bcn.ttd.net>

Oracle doesn't support nested transactions but then... What does the SavePoint Command, I've have constructed what you are saying through the Savepoint, rollback and commit statements.

begin

    update ...
    loop

        SavePoint A
            insert ...
        commit or rollback to A

    end loop
   commit or rollback
end
--

......................................................

Luis Morales Boisset - Departamento IT
Infonis International.
lboisset_at_infonis.es

Eckart Schultz escribió en mensaje <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 Wed May 19 1999 - 14:40:50 CDT