My Oracle Support Banner

DB Adapter Requires non-XA Datasource for Calling a Remote Stored Procedure that in turn Calls Another Remote Database Using DB Links (Doc ID 1446162.1)

Last updated on JULY 26, 2018

Applies to:

Oracle Service Bus - Version 10.3.1 and later
Oracle SOA Suite - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

Customer is calling a StoredProcedure via a DBAdapter Business-Service. It works to use a Non-XA Connection Factory but when using XA he is getting:

<jca:jca-runtime-fault-detail xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:jca="http://www.bea.com/wli/sb/transports/jca">
<jca:eis-error-code>24777</jca:eis-error-code>
<jca:eis-error-message>ORA-24777: use of non-migratable database link not allowed

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.