The integrity of multiple Update, Insert, and Delete of database tables can be protected through the automatic rollback by using the Database Transaction Packet component.

The Database Transaction Packet component provides the necessary rollback protection, if used. The Packet provides the standard Begin Transaction, Commit Transaction, and Rollback Transaction SQL statements (the actual syntax of statements generated internally by Scribe may vary from one RDBMS to another). After dragging the Packet object into the Procedure's Workspace, the object adopts the default Begin image shown. The image shown is modified as the various DB packet options are selected.

When a Process Procedure contains a complex combination of Update, Insert, or Delete components, then the protection afforded by the component object should be considered. When this feature is used, the Procedure should bracket the critical sections of the flowchart (the ones that make changes to the database tables) with BEGIN/COMMIT or BEGIN/ROLLBACK pairs, and make sure that either a COMMIT or a ROLLBACK is always executed before the procedure is exited.