Distributed transaction already begun "ORA 02046 " when I use Link

Question

10.1k views Asked by Homam At 13 February 2011 at 14:06

I have a very big problem for me appears with a few steps when I use devart to connect to Oracle.

Select on the following view in Oracle Code:

create or replace view Test_View as 
select "ID","USR" 
from Test_Table@link_DB; `

That's all, When I open the page the following exception will be shown (from the first time or after a postBack)

distributed transaction already begun "ORA 02046 "

Any help!

There are 2 answers

**ThinkJet** · Answer 1 · 2011-02-14 08:04:17

ThinkJet On 14 February 2011 at 08:04

There is a problem with distributed transactions state on your Oracle database servers.

Try to rollback "in-doubt" distributed transaction as described here.

Step-by-step-guide located here.

**Devart** · Answer 2 · 2011-02-14 16:20:09

Devart On 14 February 2011 at 16:20

We have replied you at our forum here.
By the way, have you tried the solution recommended by @ThinkJet?