select from dual into a variable through db links
695836Aug 27 2009 — edited Aug 31 2009HI,I need to select value of current_timestamp in to a variable d1 of a remote database inside function.
function (db_lnk varchar2)return number
as
dbl varchar2(10);
begin
dbl:=db_lnk;
select current_timestamp into d1 from dual@dbl;
....
...
end;
but getting error table or v iew does not exist.
if i do
select current_timestamp into d1 from dual@'||dbl||';
then it says database link name expected.
How to achieve this?
Thanks