Re: UTL_FILE_DIR - Can I use environment var ?

From: <jmvegalerin_at_my-deja.com>
Date: Wed, 18 Aug 1999 11:03:59 GMT
Message-ID: <7pe3uq$mjt$1@nnrp1.deja.com>

In article <7pdk8b$asl$1_at_nobel2.pacific.net.sg>, "KC" <clobiekc_at_yahoo.com> 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
>
> Thanks!
> Dawn
>
>

Hi Kevin,

The UTL_FILE package not recognise Environments variables.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 18 1999 - 06:03:59 CDT