9. Ensuring Data Integrity : Rules : Rules and Transactions
 
Share this page                  
Rules and Transactions
The statement that fires a rule and the database procedure invoked by the rule are considered part of the same single query transaction. Consequently, the database procedure invoked by the rule is executed before the statement that fired the rule completes. Because of this, you cannot issue a COMMIT or ROLLBACK statement in a database procedure invoked by a rule.
If the database procedure does not exist when the rule is invoked, or if an error occurs in the execution of a rule, the response is as if the statement firing the rule has experienced a fatal error. Any changes made to the database by the statement and any made by the fired rule are rolled back.