UTL_FILE_DIR - Can I use environment var ?
From: KC <clobiekc_at_yahoo.com>
Date: Wed, 18 Aug 1999 14:42:05 +0800
Message-ID: <7pdk8b$asl$1_at_nobel2.pacific.net.sg>
Hi,
Date: Wed, 18 Aug 1999 14:42:05 +0800
Message-ID: <7pdk8b$asl$1_at_nobel2.pacific.net.sg>
Hi,
[Quoted] 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
[Quoted] 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 [Quoted] how do I make it work ?
Thanks & Rgds
Kevin Chong
Thanks!
Dawn
Received on Wed Aug 18 1999 - 08:42:05 CEST