Transactions and Stored Procedures

Any updates done by a stored procedure become part of the transaction that called the procedure. The transaction behavior is similar to executing the sequence of c-treeACE SQL statements in the procedure directly by the calling application.

Stored procedures cannot contain COMMIT or ROLLBACK statements.