utl_file [message #252967] |
Sat, 21 July 2007 01:57  |
ramanathan manickam
Messages: 27 Registered: July 2007
|
Junior Member |
|
|
Below query does not returns me any value:
select value from v$parameter where name = 'utl_file_dir';
|
|
|
|
|
|
Re: utl_file [message #252993 is a reply to message #252985] |
Sat, 21 July 2007 03:43   |
ammishra
Messages: 179 Registered: January 2007 Location: india
|
Senior Member |
|
|
Hi Michel,
i have ran the same query in mine database.
select value from v$parameter where name = 'utl_file_dir';
output is as:
/tmp
so my qustion is the following code will work
declare
f utl_file.file_type;
s varchar2(200) := 'this is some info';
begin
f := utl_file.fopen('/tmp','test.pl','a',32767);
utl_file.put_line(f,s);
utl_file.fclose(f);
end;
i can not test it bcz that is mine production server.
--Yash
|
|
|
Re: utl_file [message #253023 is a reply to message #252993] |
Sat, 21 July 2007 10:04  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
It seems correct.
But to be sure someone have to execute it.
Regards
Michel
|
|
|