错误:ORA-01453: SET TRANSACTION 必须是事务处理的第一个语句
我的数据库处理方法:
public string ExceuteTransaction(string com1)
{
string msg = null;
using (OracleConnection connection = new OracleConnection(this._OracleConStr))
{
connection.Open();
OracleCommand oraclecom = connection.CreateCommand();
OracleTransaction oracletran = connection.BeginTransaction(IsolationLevel.ReadCommitted);
oraclecom.Transaction = oracletran;
try
{
oraclecom.CommandText = com1;
oraclecom.ExecuteNonQuery();
oracletran.Commit();
}
catch (Exception ex)
{
oracletran.Rollback();
msg = "执行失败:" + ex.Message;
}
finally
{
oracletran.Dispose();
oraclecom.Dispose();
}
}
return msg;
}
我在每次执行时都在红色字体:IsolationLevel.ReadCommitted这里报错,请问这是为什么?谢谢