4 Replies Latest reply: Jul 22, 2011 12:52 AM by Kgronau-Oracle RSS

    ORA-02047: cannot join the distributed transaction in progress

    user12294561
      Hi All,

      My requirement is to do COMMIT Transactions in BULK like 100 rows. I am doing update in Oracle and SQL Server both. Following statement update the SQL Server side:

      v_sqlstr :=
      'update JDETAIL set interfacedate = getdate() where company ='
      || v_company
      || ' and Recordnumber= '
      || TO_NUMBER (v_recordNumber)
      || ' COMMIT TRANSACTION';
      num_rows :=
      DBMS_HS_PASSTHROUGH.execute_immediate@ex_test (v_sqlstr);

      After this I am calling Oracle Update Procedure . In Oracle UPDATE Procedure when I write AUTONOMOUS TRANSACTIONS AND Commit then it works fine BUT when I don't COMMIT which I don't want because I want to COMMIT in BATCHES then following error is thrown

      ORA-02047: cannot join the distributed transaction in progress

      Thanks