Next: SQLCA interface
Up: Using the interface:
Previous: Interface Flags:
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.
Other services provided by Oracle such that SET TRANSACTION can be
effected by using db_sql/1.
- Commits all transactions up to this point.
- Rolls back all transactions since the last commit.
Note that depending on Oracle's MODE of operation some or all data manipulation
statements may execute a commit statement implicitly.