7 Replies Latest reply on Mar 17, 2016 12:26 PM by Royce Daniel

    can I use a trigger to insert to MY SQL database from oracle

    Royce Daniel

      Hi All,

       

      I tried to insert to a table to MYSQL database from oracle using trigger but I am getting the below error while inserting to the table of oracle.

       

      ORA-02047: cannot join the distributed transaction in progress

       

      CREATE OR REPLACE TRIGGER tmp.TRG_INSERT_mysql

         AFTER INSERT

         ON tmp.ora_table

         FOR EACH ROW

      BEGIN

       

       

         INSERT INTO mysqltable@TESTMYSQL1 ("description")

              VALUES ('test');

         commit;    

      END;

      /

      When I tried to insert to tmp.ora_table getting the error.

      ORA-02047: cannot join the distributed transaction in progress

       

      Regards,

      Royce Daniel