Re: No Need For UTL_FILE_DIR?

Comments below:

Anurag

"Joe" <heltibrand_at_NO_SPAMkarpel.com> wrote in message news:10ash28djd1tbb0_at_corp.supernews.com...
> So as long as there is a directory defined, you don't need to have the
> UTL_FILE_DIR=<whatever> set?

Yes. Since change to utl_file_dir requires a database bounce ... its better to use the create directory feature.
Apart from that you can grant read privs on the directory to one user and not the other.

>
> Can the directory you create be on a mapped drive (Win2K world)? From what
> I remember I could never get UTL_FILE to work with mapped drives, or any
> external drive.
>

Not sure ... I've not tried this.

--snip-- Received on Fri May 21 2004 - 15:00:31 CDT