Transaction management

Normally any changes to the database will not be committed until the user disconnects from the database. In order to provide the user with some control over this process, db_transaction/1 is provided.

db_transaction(commit)

Commits all transactions up to this point.

db_transaction(rollback)

Rolls back all transactions since the last commit.

Other services provided by Oracle such that SET TRANSACTION can be effected by using db_sql/1.

Note that depending on Oracle's MODE of operation some or all data manipulation statements may execute a commit statement implicitly.