Oracle DB Error ORA-02041 client database did not begin a transaction

The following is the cause of this error:

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 you can take to resolve this issue: If the cause is the former, check that any commit is not followed by an update.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS

Related