Distributed transaction already begun

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

What is the oracle release?

Tamil

Oracle8i Enterprise Edition Release 8.1.7.0.0

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

If you still get the error, contact Oracle Support.

Tamil

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.

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

Tamil

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.