The following example creates an OracleConnection and an ORACletion. It demonstrates how to use the BegintractionsAction, Commit and Rollback methods.
Public void runoracletion (String myConnstring) {OracleConnection myconnection = new oracleConnection; MyConnection.Open ();
OracleCommand mycommand = myconnection.createcommand (); oracletransaction myTrans;
// start a local transaction myTrans = myconnection.begintransaction (isolationled); // Assign Transaction Object for a pending local transaction mycomb.transaction = MyTrans;
try {myCommand.CommandText = "INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')"; myCommand.ExecuteNonQuery (); myCommand.CommandType = CommandType.StoredProcedure; myCommand.CommandText = " PRC_TEST "; myCommand.executenonQuery (); myTrans.commit (); console.writeline (" Both Records Are Written to Database. ");} catch (Exception E) {MyTrans.Rollback (); console.writeline (e.tostring ()); "Neither Record Was Written to Database");} finally {myconnection.close ();}}
