Re: UTL_FILE package

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