dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleConnection Class / Rollback Method
Example

In This Topic
    Rollback Method (OracleConnection)
    In This Topic
    Rolls back a transaction from a pending state.
    Syntax
    'Declaration
     
    Public Sub Rollback() 
    public void Rollback()
    Example
    The following example demonstrates how to use Commit and Rollback methods.
    public void RunOracleTransaction(string myConnString)
    {
      OracleConnection myConnection = new OracleConnection(myConnString);
      myConnection.Open();
    
      OracleCommand myCommand = new OracleCommand();
      myConnection.BeginTransaction();
      try
      {
        myCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')";
        myCommand.ExecuteNonQuery();
        myCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(60, 'PRODUCTION')";
        myCommand.ExecuteNonQuery();
        myConnection.Commit();
        Console.WriteLine("Both records are written to database.");
      }
      catch(Exception e)
      {
        myConnection.Rollback();
        Console.WriteLine(e.ToString());
        Console.WriteLine("Neither record was written to database.");
      }
      finally
      {
        myConnection.Close();
      }
    }
    Public Sub RunOracleTransaction(myConnString As String)
      Dim myConnection As New OracleConnection(myConnString)
      myConnection.Open()
    
      Dim myCommand As New OracleCommand()
      myConnection.BeginTransaction()
      Try
        myCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')"
        myCommand.ExecuteNonQuery()
        myCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(60, 'PRODUCTION')"
        myCommand.ExecuteNonQuery()
        myConnection.Commit()
        Console.WriteLine("Both records are written to database.")
      Catch e As Exception
        myConnection.Rollback()
        Console.WriteLine(e.ToString())
        Console.WriteLine("Neither record was written to database.")
      Finally
        myConnection.Close()
      End Try
    End Sub
    See Also