Procedure transactions

The procedure execution manager automatically wraps execution of the procedure with a database transaction, committing or rolling it back based on the outcome of the procedure execution.

Wrapping the procedure execution and database transaction ensures that updates to the Unica Plan database are not visible to other users until committed. It also makes the updates atomic.

The procedure writer still must acquire the necessary edit locks to ensure that other users cannot write changes to the database before the procedure execution completes.