GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

XA fails when select on databaselinks

edited May 9, 2012 11:35PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
My application uses tables/views from his own database and query some views defined with databaselink to another database.
If XA is not activated, all is OK, but when XA is up, the transaction crashes with the error ORA-24784.

example:

select (local) table1;

select (local table2

select (remote) table3 (with databaselink)

select (local) table4

insert into (local )table6

One solution is modify the code adding a commit/rollback before the call to the remote table. But we have a lot of code to review.

We are looking for another solution that not implies these changes

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center