Not for product support. If you need urgent help with your project then buy development or production support or check the known problems...
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