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_at_debian.sco.com>
Date: 20 Aug 1999 20:21:57 GMT
Message-ID: <7pkdd5$1u6$1_at_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 - 22:21:57 CEST