Re: UTL_FILE_DIR - Can I use environment var ?

From: Kirpichev Alexander <kag_at_sirena.rinet.ru>
Date: 20 Aug 1999 20:21:57 GMT
Message-ID: <7pkdd5$1u6$1@debian.sco.com>

In relcom.comp.dbms.oracle KC <clobiekc_at_yahoo.com> wrote: K> Hi,

K> Question: We are using Oracle 7.3.4 and I am using the UTL_FILE to K> output data to a file

K> In Oracle INIT.ORA, I added this sentence

K> UTL_FILE_DIR = $LOG_PATH/log
UTL_FILE_DIR = $LOG_PATH/log/

                            ^just add trailing slash here
and here:                   v   
      UTL_FILE.FOPEN('...log/'

K> where I added a line in .cshrc file for Unix userid = oracle, this sentence

K> setenv $LOG_PATH = /users/dev

K> I executed the stored procedure that calls UTL_FILE.FOPEN but I got a K> INVALID_OPERATION exception.

K> It seems it doesn't recognise Environment variable $LOG_PATH. Anyone knows K> how do I make it work ?

K> Thanks & Rgds
K> Kevin Chong

K> Thanks!
K> Dawn Received on Fri Aug 20 1999 - 15:21:57 CDT