error: ORA-04054: database link XX_LINK does not exist

From: Anthony <Anthony_at_ccm.sns.com.sg>
Date: 1995/11/02
Message-ID: <47a485$7lo_at_raffles.technet.sg>#1/1


anybody, do help and hope to get some replies.

the first impression from all is to create that XX_LINK since it does not exist.

i got the error from a simple store procedure that performs

a select from a foreign table via an Oracle link (XX_LINK)

there is already a synonym defined for tablex

the store procedure looks like:

   create or replace procedure proc_test

          (var1 in  varchar,
           var2 out varchar)
   as      parm1 number;
           parm2 number;
   begin
      select col1, col2
      into   parm1, parm2
      from   tablex
      where  colx = var1;

   end;

when i activate it from within sqlplus, the error came... OOPS (now what?)

next if i were to remove the synonym and to select from tablex_at_xx_link i'll get ORA-04054 also

why...why...why... +*tearing my hair*+

Anthony
THANKING IN ADVANCE. Received on Thu Nov 02 1995 - 00:00:00 CET

Original text of this message