Re: Help with UTL_FILE under 7.3.2?

Laurence Williams wrote:
>
> >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
>
(snip...)

Strange, on DEC unix, it works without the trailing backslash. I did find that you need to have them agree. In other words, both UTL_FILE_DIR and FOpen values must be the same.

Also, I was passing the directory and filename vlaues in as variables defined as type CHAR. This tied me in knots until I reread the argument list for FOpen and noticed that the args are of type VARCHAR2. Check that out also.

Good luck,

Bob Blizard

CMC Systems
rblizard_at_cmcsys.com Received on Fri Oct 17 1997 - 00:00:00 CEST