OracleTransaction.Rollback Method ()

.NET Framework (current version)

Note
The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Rolls back a transaction from a pending state.

Namespace: System.Data.OracleClient
Assembly: System.Data.OracleClient (in System.Data.OracleClient.dll)

Syntax

C++

Public Overrides Sub Rollback

Implements

IDbTransaction.Rollback()

Exceptions

Exception	Condition
Exception	An error occurred while trying to commit the transaction.
InvalidOperationException	The transaction has already been committed or rolled back. -or- The connection is broken.

Remarks

The transaction can be rolled back only from a pending state (after BeginTransaction has been called, but before Commit is called).

Examples

The following example creates an OracleConnection and an OracleTransaction. It also demonstrates how to use the BeginTransaction, Commit, and Rollback methods.

Public Sub RunOracleTransaction(ByVal connectionString As String)
    Using connection As New OracleConnection(connectionString)
        connection.Open()

        Dim command As OracleCommand = connection.CreateCommand()
        Dim transaction As OracleTransaction

        ' Start a local transaction
        transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted)
        ' Assign transaction object for a pending local transaction
        command.Transaction = transaction

        Try
            command.CommandText = _
                "INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')"
            command.ExecuteNonQuery()
            command.CommandText = _
                "INSERT INTO Dept (DeptNo, Dname, Loc) values (60, 'ENGINEERING', 'KANSAS CITY')"
            command.ExecuteNonQuery()
            transaction.Commit()
            Console.WriteLine("Both records are written to database.")
        Catch e As Exception
            transaction.Rollback()
            Console.WriteLine(e.ToString())
            Console.WriteLine("Neither record was written to database.")
        End Try
    End Using
End Sub

Version Information

.NET Framework
Available since 1.1