Re: Help needed on UTL_FILE

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/03/18
Message-ID: <350fb73d.17268793@www.sigov.si>#1/1

On Wed, 18 Mar 1998 09:40:32 +0100, Maarten Scharroo <m.scharroo_at_elsevier.nl> wrote:

>Hi,
>
>I'm relatively new to Unix. I created a procedure using UTL_FILE to
>create a flat-file. However I have problems with the UTL_FILE.FOPEN
>statement. It needs a location, filename and an open_mode. Typing pwd
>from the command_line gives /home/mscharro/log. Using /home/mscharro/log
>as location raises the utl_file.invalid_path exception. Can anyone
>please help.

UTL_FILE can access only the directories listed in UTL_FILE_DIR parameters in your database's init<SID>.ora parameter file. There must be separate UTL_FILE_DIR parameter for each target directory.

You must bounce the database for new parameters in your init<SID>.ora file to take effect.

>Many thanks.
>
>Maarten

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Mar 18 1998 - 00:00:00 CST