OracleLogicalTransactionStatus Class

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

Class Inheritance

System.Object

System.MarshalByRefObject

Oracle.DataAccess.Client.OracleLogicalTransactionStatus

Declaration

// C#
public sealed class OracleLogicalTransactionStatus

Requirements

Provider	ODP.NET, Unmanaged Driver	ODP.NET, Managed Driver
Assembly	`Oracle.DataAccess.dll`	`Oracle.ManagedDataAccess.dll`
Namespace	`Oracle.DataAccess.Client`	`Oracle.ManagedDataAccess.Client`
.NET Framework	2.0, 3.0, 3.5, 4.0, 4.5	4.0, 4.5

Thread Safety

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

See Also:

OracleLogicalTransactionStatus Properties

OracleLoigcalTransactionStatus properties are listed in Table 5-74

Table 5-74 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

See Also:

Committed

This property returns true if the transaction was committed.

Declaration

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

Property Value

bool

Remarks

Table 5-75 describes the possible outcomes of the Committed and UserCallCompleted properties.

Table 5-75 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.

See Also:

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 5-75 describes the possible outcomes of the Committed and UserCallCompleted properties.

See Also: