.NET中访问Oracle数据库链接:ORA-02041: client database did not begin a transaction 问题的处理。

.NET中访问Oracle中带有DB_LINK时对象时,会抛出一下异常
ORA-02041: client database did not begin a transaction
意思是要设置一个事务,但是简单的BeginTransaction
好像并不能解决问题,以下是解决的代码(针对只读情况,更新操作未作试验):
OracleCommand command = new OracleCommand();
            oracleConnection1.Open();
            command.Connection = oracleConnection1;
            command.Transaction = oracleConnection1.BeginTransaction(IsolationLevel.ReadCommitted);          
            command.CommandText = "SET TRANSACTION READ ONLY";
            OracleDataReader oraDr = command.ExecuteReader();
            command.CommandText = "select * from DGIS_SP_MIS_WORKFLOW";
 
            //command.Connection = oracleConnection1;
            //command.Transaction = oracleConnection1.BeginTransaction();
             oraDr = command.ExecuteReader(CommandBehavior.CloseConnection);
            command.Transaction.Commit();
            while (oraDr.Read() == true)
            {
                listBox1.Items.Add(oraDr.GetString(0));
            }
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值