When creating a package body i cannot have a select from another db link inside the package body? I dont know the value of the dblink name from before therefore
Create or replace package body sth as
procedure getvalues(linkname in char)
is
begin
select col1 from table1@linkname;
end getvalues;
end sth;
When i create this i get that table or view does not exist.. The link name i dont know it from before hand its in parameter which will be used as:
getvalues(linkname => dbname);
How can you have these values inside the package body?