DATABASE LINK

[tanya]

Please,help me!
I try to create this procedure :

create or replace procedure test(link_name string)
is
ls_station varchar2(3);
begin
SELECT STATION INTO ls_station FROM STATIONS@link_name ;
end test;
/

I received error :
ERROR at line 1:
ORA-04054: database link LINK_NAME does not exist

How can I send name of link to procedure and don't write select for every database ?
Thanks for help

[marist89]

LINK_NAME is taken as a literal. You will need to use dynamic sql to embed the link_name.

[padmam]

Hi Tanyya, 6th Aug 2001 20:35 hrs chennai

Welcome to DBAsupport.com.

You have by mistake posted this thread in "How to Forum".

Hence i have shifted the same to "Oracle Database Administration" forum.

Cheers

Padmam