No Need For UTL_FILE_DIR?

So as long as there is a directory defined, you don't need to have the UTL_FILE_DIR=<whatever> set?

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.

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:7nprc.190$ZQ.58_at_nwrddc03.gnilink.net...
>
> "Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message
> news:MPG.1b1831c27c36fb62989c10_at_news.individual.net...
> > In article <c8l5ht$k01$1_at_unbe.sarenet.es>, Jon says...
> > > trying to output a file using utl_file package I have created a
directory
> > > object (windows server) and UTL_FILE.FOPEN in that directory:
> > >
> > > CREATE DIRECTORY test AS 'd:\backup\test';
> > > ...
> > > DECLARE
> > > file_handle utl_file.file_type;
> > > BEGIN
> > > file_handle := utl_file.fopen ('test', 'file.txt', 'W');
> > > ...
> > >
> > > the error is the following one: ORA-29280: invalid directory path
> > >
> > >
> >
> > The CREATE DIRECTORY stuff has, as I understand it, nothing whatsoever
> > to do with using UTL_FILE.
> >
> > Instead, you need to deine a parameter UTL_FILE_DIR in the init.ora for
> > your database (or however parameter settings are managed for the db
> > version you are using - it is different with 9i)
> >
> > e.g.
> >
> > utl_file_dir = /space/utlfiledir8i
> >
> > hth
> >
> > --
> >
> > jeremy
>
> At least from 9i onwards .. create directory has everything to do with
utl_file. In fact its now
> recommended to
> use the create directory for utl_file ... instead of using the
utl_file_dir.
> The pl/sql built in packages manual mentions this.
>
> Anurag
>
>
Received on Fri May 21 2004 - 13:02:20 CDT