Re: Using UTL_FILE

For sure in Reports, maybe in Forms, you can use text_io (it has the same call syntax as utl_file).

"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
>
Received on Fri Aug 10 2001 - 08:59:54 CDT