DB Link issue

[vnktummala]

Hi-

I am getting the following error because the connect string i have given is a cursor variable not actual db link name.
select name into db_name from v$database@dbl_name;
*
ERROR at line 15:
ORA-06550: line 15, column 8:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 15, column 8:
PL/SQL: SQL Statement ignored

Can some one help me how to pass the cursor variable in place of db link connect string?

Here is my part of my code ...

...
...
open dbl_cur;
loop
fetch dbl_cur into dbl_name;
dbms_output.put_line('Fetched DB Link: '||dbl_name);
begin
select name into db_name from v$database@dbl_name;
dbms_output.put_line('Connected to '|| db_name);
end;
exit when dbl_cur%NOTFOUND;
end loop;
close dbl_cur;

Thanks in advanse.

Thanks,

[LKBrwn_DBA]

Try this:

Sql_Str Varchar2(1000);
...
...
Open Dbl_Cur;
Loop
  Fetch Dbl_Cur Into Dbl_Name;
    Dbms_Output.Put_Line('Fetched Db Link: '||Dbl_Name);
    Begin
      Sql_Str:='Select Name From V$Database@'||Dbl_Name;
      Execute Immediate Sql_Str Into Db_Name;
      Dbms_Output.Put_Line('Connected To '|| Db_Name);
    End;
  Exit When Dbl_Cur%Notfound;
End Loop;
Close Dbl_Cur;

[vnktummala]

Awesome !!! It's perfectly working ... Thanks Brwn.

Thanks,