I'm using Atomikos XA transaction with oracle 10 g database. I get the "ORA-24777: use of non-migratable database link not allowed" error when a select statement is executed on another db from a stored procedure. I can't remove all the statements, we have a lot of queries retrieving data from remote databases.
I haven't this problem when I'm using a simple datasource.
The solution that I found is to install the oracle MTS. I read a article describing impacts and when to use MTS
Is installing MTS the only issu? Can we configure xadatasource to solve this problem?
Please I need Help.
I believe that enabling MTS in oracle is the only issue to solve the "ORA-24777: use of non-migratable database link not allowed" error when we deal with db links.
I found the response to my question in the oracle XA documentation http://download-east.oracle.com/docs/cd/B13789_01/appdev.101/b10795/adfns_xa.htm#1007057
This topic is archived. No further replies will be accepted.Other recent topics