Re: Using UTL_FILE

In article <ygCc7.1614$Xf5.60065_at_news.infostrada.it>, "carlog" says...
>
>hi all,
>only a little question, is possibile write an output file from PL/SQL and
>save data into a local directory, but i don't want use the path stored in
>'utl_file_dir' parameter.
>
>thank in advance
>
>carlo
>
>
>

no, utl_file will explicitly only write/read from directories specified in the utl_file_dir init.ora parameter.

This is to prevent someone from doing something like:

utl_file.fopen( '/export/home/oracle/oradata/mysid/system.dbf', 'w' );

and erasing the sytem datafile for example.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp