Re: UTL_FILE_DIR - Can I use environment var ?

Hi Kevin;

As far as I know all file names/locations in Init.Ora (Utl_File_Dir, User_Dump_Dest and so on...) have to be absolute path and file names.

Eike

KC wrote:

> Hi,
>
> Question: We are using Oracle 7.3.4 and I am using the UTL_FILE to
> output data to a file
>
> In Oracle INIT.ORA, I added this sentence
>
> UTL_FILE_DIR = $LOG_PATH/log
>
> where I added a line in .cshrc file for Unix userid = oracle, this sentence
>
> setenv $LOG_PATH = /users/dev
>
> I executed the stored procedure that calls UTL_FILE.FOPEN but I got a
> INVALID_OPERATION exception.
>
> It seems it doesn't recognise Environment variable $LOG_PATH. Anyone knows
> how do I make it work ?
>
> Thanks & Rgds
> Kevin Chong

Received on Fri Aug 20 1999 - 09:01:50 CDT