ORA-01729: database link name expected Options

[Aruns]

Hi

I need to fetch values form another db(Its should be hard coded)

So i used bind variable concept

But it throws an error
ORA-01729: database link name expected


declare
var1 varchar2(100);
var2 varchar2(300);
var3 varchar2(3);
begin
var1:='INT.VERL.COM';
var2:='select * from table_part_num@'||':var1'||'where p_code=:var3';
execute immediate var2 using var1,'''||var3||''';
end;


How to pass the link name in exceute immediate

[Aruns]

Hi

I need to fetch values form another db(Its should not be hard coded)in .Using oracle sqlplus

So i used bind variable concept

But it throws an error
ORA-01729: database link name expected
declare
var1 varchar2(100);
var2 varchar2(300);
var3 varchar2(3);
begin
var1:='INT.VERL.COM';
var2:='select * from table_part_num@'||':var1'||'where p_code=:var3';
execute immediate var2 using var1,'''||var3||''';
end;
How to pass the link name in exceute immediate

[burleson]

Hi Aruns,

First, ensure that your command works with a variable:

select * from table_part_num@mydb where p_code=1;

Then, de-bug your code to display your :var values with dbms_put_line.

See Dr. Hall's PL/SQL book for PL/SQL debugging tips:

http://www.rampant-books.com/book_2006_1_plsql_tune.htm