Applies To
OraConnection
OraDatabase
OraSession
Description
Ends the current transaction and commits all pending changes to the database.
Usage
oraconnection.CommitTrans
oradatabase.CommitTrans
orasession.CommitTrans
Remarks
Oraconnection, OraDatabase: CommitTrans commits all pending transactions for the specified connection.
This method has no effect if a transaction has not begun. When a session-wide
transaction is in progress, you can use this method to commit the transactions for
the specified connection prematurely.
Orasession: CommitTrans commits all transactions present within the session. CommitTrans
is valid only when a transaction has been started. If a transaction has not
been started, use of CommitTrans causes an error.
Note: If an OraDatabase object has been enlisted with Microsoft Transaction Server (MTS) and is part of a global MTS transaction, this method has no effect.