使用transactionscrope时如：

using (TransactionScope scop = new TransactionScope())
                    {
                        OracleCommand cmd = new OracleCommand("insert into TMP_TEST values('" + DateTime.Now + "')", con, tran);
                        con.Open();


                        var result2 = cmd.ExecuteNonQuery();

                        OracleCommand cmd3 = new OracleCommand("select COL1 from tmp_test", con);
                        var t2 = cmd3.ExecuteOracleScalar();
                        Console.WriteLine("2受影响的行数：" + result + "||当前临时表数量：" + t2);
                        
                        
                        OracleDataAdapter da = new OracleDataAdapter("select  * from TMP_TEST", con);
                        DataTable dt = new DataTable();
                        da.Fill(dt);
                        Console.WriteLine("3受影响的行数：" + result2 + "||当前临时表数量：" + dt.Rows.Count);
                        scop.Complete();
                    }

当启用高并发时，报错14450，并发实现为：

for(inti =0; i <100; i++)

{

newThread(newParameterizedThreadStart(new Class1().Func1)).Start(i);

}

ITPub博客

TransactionScope 访问Oracle临时表时高并发 14450错误

最新文章