Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE-Package
Make sure file read permissions are available to all
chmod 444 file
mme wrote in message <7k06vu$t8n$2_at_news00.btx.dtag.de>...
>Hi all of you!
>
>I´m experiencing problems using the UTL_FILE package.
>Creating textfiles isn´t a problem, but reading textfiles. ORA
>always reports "error opening file". I´ve checked the
>rights and stuff (Unix) and it´s always ASCII files.
>
>The only file that works is the ones ORA created.
>"Foreign" files get always rejected. I´ve tried with
>CR and CR/LF at the end of every line.
>
>Does ORA always have to be owner of the files, or
>is it enough to have rights on them?
>
>Is there a difference between a file created using UTL_FILE
>or a foreign plain ASCII file?
>
>Please help me?
>
>Regards,
>
>Mattias
>
Received on Sun Jun 13 1999 - 07:35:47 CDT