CommitTrans Method

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.