OracleLogicalTransactionStatus Class

The OracleLogicalTransactionStatus class provides information on the status of a logical transaction.

This class has been deprecated in ODP.NET 12.1.0.2. It will be desupported in a future release.

Class Inheritance

System.Object

  System.MarshalByRefObject

    Oracle.DataAccess.Client.OracleLogicalTransactionStatus

Declaration

// C#
public sealed class OracleLogicalTransactionStatus

Requirements

Provider ODP.NET, Unmanaged Driver
Assembly Oracle.DataAccess.dll
Namespace Oracle.DataAccess.Client
.NET Framework 3.5, 4.0, 4.5

Thread Safety

All public static methods are thread-safe, although instance methods do not guarantee thread safety.

OracleLogicalTransactionStatus Properties

OracleLoigcalTransactionStatus properties are listed in Table 6-94

Table 6-94 OracleLogicalTransactionStatus Properties

Property Description

Committed

Specifies if a transaction was committed

UserCallCompleted

Specifies if the application expects additional data such as PL/SQL out binds or DML to be returned with the COMMIT or if the COMMIT is part way through a PL/SQL


Committed

This property returns true if the transaction was committed.

Declaration

// C#
public bool Committed {get; set;}

Property Value

bool

Remarks

Table 6-95 describes the possible outcomes of the Committed and UserCallCompleted properties.

Table 6-95 Outcome of OracleLogicalTransactionStatus Properties

Committed Value UserCallCompleted Value Outcome

false

false

The call did not execute the commit.

true

true

The call did execute the commit and there was no additional information to return and no more work to do if that call was a PL/SQL procedure.

true

false

The transaction is committed, but the information returned may be incomplete and/or not all expected work was completed. Examples of incomplete information or incomplete work done include: the number of rows modified when using autocommit or commit on success, parameter and function results when calling PL/SQL procedures, or PL/SQL procedures with more work to do after the commit. In order to function correctly, .NET applications that use data returned from the commit must check the UserCallCompleted value.


UserCallCompleted

This property returns true if the application expects additional data such as PL/SQL out binds or DML to be returned with the commit or if the commit is part way through a PL/SQL procedure.

Declaration

// C#
public bool UserCallCompleted {get; set;}

Property Value

bool

Remarks

Table 6-95 describes the possible outcomes of the Committed and UserCallCompleted properties.