Re: UTL_FILE_DIR - Can I use environment var ?

From: <david.archer_at_chase.com>
Date: Fri, 20 Aug 1999 14:39:40 GMT
Message-ID: <7pjpb9$r49$1@nnrp1.deja.com>

No but we have taken a different approach. We have a package with constants in it. We then defined the output directory there and use that everywhere. While not as fool proof as your method it does provide a good level of control.

HTH, David Archer

In article <7pid8n$g7p$1_at_newton.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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 20 1999 - 09:39:40 CDT