How to fix the Oracle error ORA-24772: Cannot mix tightly-coupled and loosely-coupled branches?

In this post, you’ll learn more about the Oracle ErrorORA-24772: Cannot mix tightly-coupled and loosely-coupled branches with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-24772: Cannot mix tightly-coupled and loosely-coupled branches

Reason for the Error ORA-24772: Cannot mix tightly-coupled and loosely-coupled branches

Application attempted to start a transaction with a global transaction identifier and a wrong option.

How to fix the Error ORA-24772: Cannot mix tightly-coupled and loosely-coupled branches ?

You can fix this error in Oracle by following the below steps

Verify that all branches of a global transaction are started with either OCI_TRANS_TIGHT or OCI_TRANS_LOOSE option. If the application is correct and uses distributed updates, contact customer support.