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-Package

Re: UTL_FILE-Package

From: Paul Q <paulq_at_home.com>
Date: Sun, 13 Jun 1999 12:35:47 GMT
Message-ID: <DAN83.7701$Yr2.124726@news2.rdc1.on.home.com>


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

Original text of this message

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