Re: File I/O from Oracle 7.3 PL SQL

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/10/03
Message-ID: <3434C1AA.B90F3FCE@gatwick.geco-prakla.slb.com>#1/1

Have you set the UTL_FILE_DIR init.ora parameter?

This dictates which directories you will be allowed to write to and can occur many times in the init.ora file for multiple directories. You can set it to * for all directories, however this is not advised as the user executing UTL_FILE has the oracle owners file permissions (due to the setuid of the oracle executable) which may be higher than required.

Cheers,

Ian Received on Fri Oct 03 1997 - 00:00:00 CDT