Home » SQL & PL/SQL » SQL & PL/SQL » utl_file
utl_file [message #252967] Sat, 21 July 2007 01:57 Go to next message
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 #252969 is a reply to message #252967] Sat, 21 July 2007 02:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Then you didn't set it.

Regards
Michel
Re: utl_file [message #252970 is a reply to message #252969] Sat, 21 July 2007 02:10 Go to previous messageGo to next message
ramanathan manickam
Messages: 27
Registered: July 2007
Junior Member
how to set it?
Re: utl_file [message #252985 is a reply to message #252970] Sat, 21 July 2007 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Like the other configuration parameter.
Of course this depends what kind of configuration parameter you use. If you don't know, ask your DBA as only a DBA can change this.

But the question is: do you really need to use this parameter?
And the answer depends on the version you didn't post.

Regards
Michel
Re: utl_file [message #252993 is a reply to message #252985] Sat, 21 July 2007 03:43 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems correct.
But to be sure someone have to execute it.

Regards
Michel
Previous Topic: procedure result inserting into file now want to as result set
Next Topic: limit the returned size of query
Goto Forum:
  


Current Time: Fri Dec 09 21:21:29 CST 2016

Total time taken to generate the page: 0.36579 seconds