Re: Help with UTL_FILE under 7.3.2?

From: Laurence Williams <laurence.williams_at_gecm.com>
Date: 1997/10/15
Message-ID: <3444aaa8.3292588@news.geccs.gecm.com>#1/1

>Okay, what do you do when you *still* get invalid_path even with
>utl_file_dir defined and the database restarted?
>
>Info:
>
>in initSID.ora:
>
>UTL_FILE_DIR = /usr/local/chat/conf

Erm, i havent followed the full thread on this, but i have just had the same sort of problem

Eventually sorted it out because the definition _NEEDS_ the trailing backslash

ie.
UTL_FILE_DIR = /u03/chat/conf
will _NOT_ work

UTL_FILE_DIR = /u03/chat/conf/

_WILL_ work

and dont forget to put the trailing '/' in the calls to UTL_FILE procedures

ie UTL_FILE.FOPEN('/u03/chat/conf/','fred.txt','R')

again, lack of the trailing '/' in the path _WILL_ cause it to fail.

sorry if you've already tried this, but it confused me for most of a day!

Laurence Williams
'Any suggestions or solutions are my own and are used at your own risk'

All views expressed are my own
and carry no guaruntees.
Believe them at your own risk. Received on Wed Oct 15 1997 - 00:00:00 CDT