Re: UTL_FILE Problem

Dirk Mika wrote:
>
> 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.
>

the oracle owner needs access to the file, seems like this is working through group membership (the second 6 in 664). If you use a fresh file name for writing and check the group on it after Oracle has created it you'll see wot i mean. Received on Tue Sep 05 2000 - 04:37:22 CDT