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
end;
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