Re: file access with UTL_FILE

From: AlexJent <alexjent_at_aol.com>
Date: 1997/01/21
Message-ID: <19970121015800.UAA17892@ladder01.news.aol.com>#1/1

>>>- You Said

---

I am trying to access files by invoking the UTL_FILE package. Unfortunately the FOPEN procedure raises an INVALID_PATH exception, and I have no idea why.

Could it be I have provided the wrong parameter in initSID.ora?

UTL_FILE_DIR = '/user/oracle/mydir'

>>>----I Said

---

I have been using this new feature with great success....

Run the following to see just what you have in there....

 select value from v$parameter where name = 'utl_file_dir' ;

Also, I haven't tried it....but, believe you can update this parameter(if you are one of the privileged few!) avoiding the need to re-boot.... Let us know!

Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954 E-Mail: infosys_at_aol.com

E-Mail Work: jentilucci_at_notes.seagate.com

          Home: AlexJent_at_aol.com Received on Tue Jan 21 1997 - 00:00:00 CST