Re: Help with UTL_FILE under 7.3.2?

Tina Tran wrote:
>
> Modify your init$ORACLE_SID.ora file to include utl_file_dir parameter
> which specifies
> directories that you can access.
>

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

OR

UTL_FILE_DIR = /u03/chat/conf

OR

UTL_FILE_DIR = * It still fails with invalid_path, regardless of how UTL_FILE_DIR is defined. I've tried it uppercase and lowercase. What the heck am I doing wrong?? I've restarted the database each time I've changed it, plus I've rebooted a few times...

All I want to do is read in a file! Gee whiz!!

Thanks...

Leslie

-- 
Leslie Dreyer Kalra
Techies, Inc.
lbd_at_techiesinc.com