关于一个oracle分布式事务的问题（在线等）

fzy8888cn

用EJB3.0开发JAVA的程序，用到两个oracle数据库（10g），用java程序调用连个数据库上的存储过程，
其中一个一个存储过程中带自制事务，（PRAGMA   AUTONOMOUS_TRANSACTION;......COMMIT;）
结果在调用中报错。如下：

ORA-00164 在可移植分布式事务处理中不允许分布式自治事务处理

当然去掉自制事务可以解决，
请教各位如果不能去掉自制事务那该怎么处理？

ziggler

那就不要使用可移植分布式事务处理

fzy8888cn

说了等于没说

dingning239

主题:         Calling Remote Stored Procedure via Database Link Fails, ORA-00164
          文档 ID:         152916.1         类型:         PROBLEM
          上次修订日期:         25-JUL-2005         状态:         PUBLISHED

    * fact: Oracle Server - Enterprise Edition 8.1
    * symptom: Calling remote stored procedure via database link fails
    * symptom: ORA-00164: autonomous transaction disallowed within distributed transaction
    * cause: Bug 692232 Distributed autonomous tests hang Autonomous transactions are not supported within distributed transaction in Oracle8i. Even though some part of this functionality may work fine in Oracle versions before 8.1.7, the combination of the autonomous transactions and distributed transactions features was not supported. This was enforced by reporting ORA-00164 in Oracle 8.1.7. This feature is supported in Oracle 9iR2.



fix:

Do not use autonomous transactions within distributed transaction in Oracle8i or
upgrade to Oracle 9iR2.

fzy8888cn

原帖由 dingning239 于 2009-8-6 16:58 发表
主题:         Calling Remote Stored Procedure via Database Link Fails, ORA-00164
          文档 ID:         152916.1         类型:         PROBLEM
          上次修订日期:         25-JUL-2005         状态:         PUBLISHED

    * fact: Oracle Server - En ...

大哥，我本来就用的10G