Re: UTL_FILE package
From: Anurag Varma <avdbi_at_hotmail.com>
Date: Fri, 21 May 2004 15:14:52 GMT
Message-ID: <M1prc.115$ZQ.80_at_nwrddc03.gnilink.net>
Date: Fri, 21 May 2004 15:14:52 GMT
Message-ID: <M1prc.115$ZQ.80_at_nwrddc03.gnilink.net>
"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 - 17:14:52 CEST