is this possible [message #37942] |
Thu, 07 March 2002 10:38 |
Suresh
Messages: 189 Registered: December 1998
|
Senior Member |
|
|
Hi,
iam reading a value from a file into a string
and iam trying to execute a select statement appending
the string to the select statment.
Ex: reading hostname from a file
select * from remotetable@hostname where remoteid = 1;
Is this rightway to do?
appreciate any sample code.
Thanks
suresh
|
|
|
Re: is this possible [message #37944 is a reply to message #37942] |
Thu, 07 March 2002 10:54 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
1) read string using utl_file package
2) use dynamic sql
declare
f UTL_FILE.FILE_TYPE;
l_str varchar2(30);
type r is refcursor;
r1 r;
begin
f := UTL_FILE.FOPEN('c:myutildir', 'x.txt', 'r');
utl_file.get_line(f,l_str);
utl_file.fclose(f);
open r1 for 'select * from remotetable@'||l_str||' where remoteid = 1'
...
...
close r1;
end;
|
|
|