Re: Help with UTL_FILE under 7.3.2?

On Fri, 17 Oct 1997 21:48:50 -0400, Bob Blizard <gblizard_at_ma.ultranet.com> wrote:

>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

just get the dba to set UTL_FILE_DIR = * and you can read and write to any directory oracle as a user has access. works for me Received on Sat Oct 25 1997 - 00:00:00 CEST