Re: file access with UTL_FILE

Rainer Hoerbe wrote:
>
> On Mon, 20 Jan 1997 22:13:38 -0800, Klaus Schliffenbacher
> <sf_at_iwb.mw.tu-muenchen.de> wrote:

The problem is that you are using the single quotes. You must leave them out. ie:

UTL_FILE_DIR=/usr/oracle/mydir

I've had it working - although I can't seem to write a lot of LONG data to it. After a certain stage it will get a write error. Very frustrating as the errors are not predictable. I've tried the FFLUSH to no avail. So my program crashes randomly after trying to write too much to the file.

Good luck,
Leng.

>
> >I am trying to access files by invoking the UTL_FILE package.
> >Unfortunately the FOPEN procedure raises an INVALID_PATH exception, and
> >I have no idea why.
> >
> >Could it be I have provided the wrong parameter in initSID.ora?
> >
> >UTL_FILE_DIR = '/user/oracle/mydir'
> >
> >I am working with ORACLE 7.3, Irix 6.2
> >
> >Klaus Schliffenbacher
> >sf_at_iwb.de
>
> I am experiencing tha same problim on Irix 6.4 and NT 4,0. It tried 15
> different possibilities of writing the path - no success.
>
> If you have any success, please let me know.
>
> Rainer
> rhoerbe_at_netpromote.co.at
Received on Fri Jan 24 1997 - 00:00:00 CST