oracle 当我使用 Link 时,分布式事务已经开始“ORA 02046”

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/4984564/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-18 22:44:55  来源:igfitidea点击:

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

.netoracledevart

提问by Homam

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

我有一个非常大的问题,当我使用时出现了几步 devart 连接到 Oracle。

  • Select on the following view in Oracle Code:

    create or replace view Test_View as 
    select "ID","USR" 
    from Test_Table@link_DB; `
    
  • Using LINQ CONNECT MODAL

  • 在 Oracle 代码中的以下视图中选择:

    create or replace view Test_View as 
    select "ID","USR" 
    from Test_Table@link_DB; `
    
  • 使用 LINQ 连接模式

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

就是这样,当我打开页面时,将显示以下异常(从第一次或 postBack 之后)

distributed transaction already begun "ORA 02046 "

分布式事务已经开始“ORA 02046”

Any help!

任何帮助!

回答by ThinkJet

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

Oracle 数据库服务器上的分布式事务状态存在问题。

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

尝试按此处所述回滚“有疑问”的分布式事务。

Step-by-step-guide located here.

分步指南位于此处

回答by Devart

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

我们已经在我们的论坛上说你在这里
顺便问一下,您是否尝试过@ThinkJet 推荐的解决方案?