Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE Problem
Hi,
> UTL_FILE contains some user defined exception listed in
> package specification.
>
> invalid_path EXCEPTION;
> invalid_mode EXCEPTION;
> invalid_filehandle EXCEPTION;
> invalid_operation EXCEPTION;
> read_error EXCEPTION;
> write_error EXCEPTION;
> internal_error EXCEPTION;
>
> These ones appears with wrong work with files or wrong
> permissions ...etc. You have to catch these exception in your
> PL/SQL program to ensure all is done right
>
> Starous
I finaly find it to be a matter of filepermissions. I'm the owner of the file i tend to write to, but i have to set permissions to 664. I have to figure out why, but it works for this time.
Many thanks to all.
Regards
Dirk Mika
-- Bayer AG WD-AED /LEV D-51368 Leverkusen Telefon: +49 (214) 30-50360 Telefax: +49 (214) 30-20031 Email : dirk.mika.dm1_at_bayer-ag.deReceived on Tue Sep 05 2000 - 01:01:27 CDT