1 Reply Latest reply: Nov 8, 2012 3:11 AM by user648708 RSS

    Error when i create a subconsult with dblink between 3 instances.

    user12057136
      Hi,

      I have 3 instances and i want to work between then. The error ocurrs when i use subquery, This is the code:

      update erie.rie_cbtrega@l$e_tfcries rgr
      set rgr.c_descri = ( select rg.c_descri
      from dadm.cbtrega@l$e_tfccie rg
      where rg.c_idrega = rgr.c_idrega
      )
      ;

      When i execute upadte without subquery "( select rg.c_descri from dadm.cbtrega@l$e_tfccie rg where rg.c_idrega = rgr.c_idrega)" the result is successfully, but when i add subquery the result is

      ORA-02019: no se ha encontrado la descripción de la conexión para la base de datos remota
      ORA-02063: line precediendo a TFCCIE
      ORA-02063: 2 lines precediendo a L$E_TFCRIES

      Regards.