C# Oracle Transaction

Open Oracle connection:

OracleConnection oraConn;
string oraConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
oraConn = new OracleConnection(oraConnString);
oraConn.Open();
OracleCommand myCommand = oraConn.CreateCommand();

=============================================================

Begin transaction:

OracleTransaction trans = oraConn.BeginTransaction(IsolationLevel.ReadCommitted);

=============================================================

Usage:

try
{
    myCommand.Transaction = trans;

    myCommand.CommandText =  

    "INSERT INTO Dept values (50, 'TECHNOLOGY', 'DENVER')";
    myCommand.ExecuteNonQuery();
    myCommand.CommandText = 

    "INSERT INTO Dept values (60, 'ENGINEERING', 'KANSAS CITY')";
    myCommand.ExecuteNonQuery();

    trans.Commit();
}
catch (Exception e)
{
    trans.Rollback();
}