Re: Nested Transaction Level

From: Frank <franjoe_at_frisurf.no>
Date: Thu, 8 Mar 2001 20:16:52 +0100
Message-ID: <8ZQp6.10293$t21.277051@news3.oke.nextra.no>

Hi!

When you perform a commit; or rollback; all outstanding transaction in you current session
are handled, regardless of which procedure/function-stack level you are in.

So; yes the commit in SP_BBB will commit everyting since the last commit/rollback (including rollback to savepoints) in the session (also if that was "outside" SP_AAA"), and your savepoint will be lost. If you wish these to procedures to have a transaction-context each, perhaps you should look at
Autonomus Transactions in Oracle 8(?)/8i. Otherwise, you can remove the commit in SP_BBB because it will be commit'ed in SP_AAA anyway.

Frank Received on Thu Mar 08 2001 - 13:16:52 CST