Hello, > On Mar 22, 2025, at 08:38, Kevin Stephenson <kjs...@hotmail.com> wrote: > • When a top-level stored procedure is called it implicitly creates a TX > if there is no current TX. > • When a BEGIN/EXCEPTION block is used it implicitly creates a subTX for > that block.
These statements are correct. > • When a nested stored procedure is called it implicitly creates a subTX > for that invocation. This one is not. (Although the behavior you are looking for may not depend on that.) A procedure cannot issue top-level transaction control statements from within an exception block, and attempting to do so raises the error you saw. This includes procedures that are called from within an exception block.
