PL/SQL: cascaded transactions?

From: Eckart Schultz <es_at_dcs.de>
Date: Tue, 18 May 1999 15:57:01 +0200
Message-ID: <7hrrjj$61h$1@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 - 08:57:01 CDT