Re: UTL_FILE package

"Jon" <aaa_at_bbb.ccc> wrote in message news:c8l5ht$k01$1_at_unbe.sarenet.es...
> 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
>
>

Try:

file_handle := utl_file.fopen('TEST',file.txt','W');

.... case sensitive.

Anurag Received on Fri May 21 2004 - 10:14:52 CDT