BeginTrans Method

See Also

Example

Applies To

OraConnection

OraDatabase

OraSession

Description

Begins a database transaction within the specified session.

Usage

oraconnection.BeginTrans

oradatabase.BeginTrans

orasession.BeginTrans

Remarks

After this method has been called, no database transactions are committed until a CommitTrans is issued. Alternatively, the session can be rolled back using Rollback. If a transaction has already been started, repeated use of BeginTrans causes an error.

If Update or Delete methods fail on a given row in a dynaset in a global transaction after you issue a BeginTrans, be aware that locks will remain on those rows on which you called Update or Delete. These locks will persist until you call CommitTrans or Rollback.

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.