Re: file access with UTL_FILE

Klaus Schliffenbacher <sf_at_iwb.mw.tu-muenchen.de> wrote:

>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 am working with ORACLE 7.3, Irix 6.2
>
>Klaus Schliffenbacher
>sf_at_iwb.de

You can't open files in any directory you want. The allowable directories must be specified in the init file with the UTL_FILE_DIR parameter.

This is because anything written using UTL_FILE is being written with the permissions of whoever started the database. That could be an enormous security hole if they had free reign of the system.

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!