| 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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
