Re: UTL_FILE package

"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 - 10:37:39 CDT