UTL_FILE_DIR - Can I use environment var ?

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

Thanks!
Dawn Received on Wed Aug 18 1999 - 01:42:05 CDT