Re: Nested Transaction Level

From: Frank <franjoe_at_frisurf.no>
Date: Mon, 12 Mar 2001 16:58:22 +0100
Message-ID: <4r6r6.3968$tR1.39763@news1.oke.nextra.no>

Hi!

Could you solve it in the same way for both cases if you always commit at the procedure/function level that is earliest?

This means that none of these two functions commit's or rollback's, that is entierly handled by the calling-logic.

e.g Call SP_AAA from calling-logic:

...
..

BEGIN
...
...

        SAVEPOINT savepoint1;
        SP_AAA;
        COMMIT;
EXCEPTION
        WHEN OTHERS
            THEN ROLLBACK TO savepoint1;

END;

e.g call SP_BBB from calling logic:

...
..

BEGIN
...
...

        SAVEPOINT savepoint1;
        SP_BBB;
        COMMIT;
EXCEPTION
        WHEN OTHERS
            THEN ROLLBACK TO savepoint1;

END; You probably have to remove the EXEPCTION handlig as you have suggestet it in
your example, or just re-RAISE the exception.

Frank Received on Mon Mar 12 2001 - 09:58:22 CST