CommitTrans Method

See Also

Example

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.