Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE Problem

Re: UTL_FILE Problem

From: Dirk Mika <dirk.mika.dm1_at_bayer-ag.de>
Date: Tue, 05 Sep 2000 08:01:27 +0200
Message-ID: <39B48C37.CD7FF8A@bayer-ag.de>

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.de
Received on Tue Sep 05 2000 - 01:01:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US