public void TransTest()
{
string connString = "Data Source=Oracle9i_kestrel;User ID=system;Password=asdf;Unicode=True ";
OracleConnection oraConn = new OracleConnection(connString);
oraConn.Open();
OracleTransaction oraTrans = oraConn.BeginTransaction(IsolationLevel.ReadCommitted);
OracleCommand oraComm = oraConn.CreateCommand();
oraComm.Transaction = oraTrans;
try
{
oraComm.CommandText = "insert into ta values( 'aaa ', 'aaa ') ";
oraComm.ExecuteNonQuery();
oraComm.CommandText = "insert into tb values( 'aaa ', 'bbb ') ";
oraComm.ExecuteNonQuery();
oraTrans.Commit();
}
catch
{
oraTrans.Rollback();
}
}
{
string connString = "Data Source=Oracle9i_kestrel;User ID=system;Password=asdf;Unicode=True ";
OracleConnection oraConn = new OracleConnection(connString);
oraConn.Open();
OracleTransaction oraTrans = oraConn.BeginTransaction(IsolationLevel.ReadCommitted);
OracleCommand oraComm = oraConn.CreateCommand();
oraComm.Transaction = oraTrans;
try
{
oraComm.CommandText = "insert into ta values( 'aaa ', 'aaa ') ";
oraComm.ExecuteNonQuery();
oraComm.CommandText = "insert into tb values( 'aaa ', 'bbb ') ";
oraComm.ExecuteNonQuery();
oraTrans.Commit();
}
catch
{
oraTrans.Rollback();
}
}