Distributed transaction already begun

[vijaymohan]

I have created a database link, I got the following error when i am tring to get the data from remote database.

ORA-02046: distributed transaction already begun
ORA-02063: preceding line from DB_LINK1.
Oracle8i Enterprise Edition Release 8.1.7.0.0

Please help me out.

Thanks,
Vijay

[tamilselvan]

What is the oracle release?

Tamil

[vijaymohan]

Oracle8i Enterprise Edition Release 8.1.7.0.0

[tamilselvan]

Increase the value of distributed_transactions init parameter to 150 and try again.

If you still get the error, contact Oracle Support.

Tamil

[vijaymohan]

already the parameter value in init.ora is 500 i had increased it to 600 but there is no change.The error message is still coming.

[tamilselvan]

Issue a commit after the select statement.
May be this will solve your problem.

Tamil

[loderunner]

For everyone else still struggling with this error...
On 10g I have found a workaround that works for smaller linked tables. The table that was causing the problem was a link to a link on another server. I now create a temp table and copy the whole linked table to the server I am on at the beginning of my proc. Then, instead of the linked table I use the temp table and my proc works.