Re: Using UTL_FILE

In article <uNRc7.944$HR5.988022_at_news1.news.adelphia.net>, "Scott says...
>
>For sure in Reports, maybe in Forms, you can use text_io (it has the same
>call syntax as utl_file).

which is safe (unlike blindly using utl_file) since forms/reports is either

o running on the client (not as oracle) and would not be able to damage any critical files on the server

o running on a middle tier (not as oracle the database) and would not be able to damage any critical files on the server

>
>"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message
>news:9kvda601gpt_at_drn.newsguy.com...
>> 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
>>
>
>

--
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