ORA-02041 client database did not begin a transaction
Cause: An update occurred at a coordinated database without the coordinator beginning a distributed transaction. This may happen if a stored procedure commits and then performs updates, and the stored procedure is invoked remotely. It could also happen if an external transaction monitor violates the XA protocol.Action: If the cause is the former, check that any commit is not followed by an update.
Cause: An update occurred at a coordinated database without the coordinator beginning a distributed transaction. This may happen if a stored procedure commits and then performs updates, and the stored procedure is invoked remotely. It could also happen if an external transaction monitor violates the XA protocol.Action: If the cause is the former, check that any commit is not followed by an update.
具体在什么条件下发生?
如:我有数据库db1,db2
db1中有表 table1
db2 中执行insert into table1@db2 values(***,***,sysdate);
他就出现了!
不过只是在应用程序调用时!我用的是pl/sql develop
里面有一个test的工具,这里测试是没问题的
关键还是“ORA-02041: 客户数据库未开始一个事务处理”