2 Replies Latest reply: May 9, 2014 8:39 AM by CraigB RSS

    heterogeneous connectivity issue with oracle procedure

    1014035

        I am using a heterogeneous connectivity from oracle. I am Using DB link to retrieve
      some data from sql server. If I am running the query from anonymous block using
      dblink, it is working fine. But if I put the same code in procedure, it is
      giving

       

       

      Error code: -2019

       

       

      Error msg: ORA-02019: connection description for remote database not found

       

       

      can any one help?