Re: Question about utl_file

Reid Lai wrote:
>
> First of all, you should log in as oracle and try to create a text file under
> your destination. If not, please check the os permission.

I'll add second and third:

second:
  Buy yourself the O'Reilly book 'Oracle Built-in Packages' by   Beresniewicz, Dye and Feuerstein, it will save you lots of   time. UTL_FILE among others is described in that book.

third: (Because I have been mislead myself by some 'documentations')   Do not end the path with a slash/backslash.   This is right:
    In init.ora:
      utl_file_dir = /usr/oratextfiles
    In your program:
     my_file := Utl_File.Fopen ('/usr/oratextfiles', 'test.txt', 'W');

ninetyninth is 'you have restarted your database since adding the utl-entries in init.ora?'

Regards, Njål

> DBi1067305 wrote:
>
> > Hi.
> >
> > I'm trying to use the utl_file package in Oracle 7.3 to read a flat file
> > (UNIX). I've updated the init.ora file to include the parameter utl_file_dir
> > which specifies the accessible directory path (as described in the
> > documentation). However, the function in utl_file still returns an error for
> > invalid path. I can't seem to find the problem and would welcome any
> > suggestions on what to look for.
> >
> > Please reply to maestro_98_at_hotmail.com.
> >
> > Thanks,
> > Devyani
>
> --
> Best Regards,
>
> Reid Lai
Received on Sun May 30 1999 - 16:41:17 CDT