how to refer unix env. variable into pl/sql block ?

From: RATHANB <rathanb_at_cs.com>
Date: 11 Apr 2000 03:03:03 GMT
Message-ID: <20000410230303.10363.00000789_at_ng-bj1.news.cs.com>

Hi all
[Quoted] [Quoted] I would like to refer a unix env. variable into pl/sql block. For example I got pl/sql procedure that will run from unix, where I need to refer one of the unix env. variable.
Let's say unix env. variable:
[Quoted] [Quoted] INT_OUTDIR set to '/usr/oracle/11.0/out'

Now, can I refer INT_OUTDIR into my procedure where I will use to write files to this specific directory?
[Quoted] [Quoted] If so how, I know that precompilers can be used to do this, but I am looking to [Quoted] [Quoted] refer this dynamic variable into my pl/sql block? Reason is that that directory [Quoted] path could be changed from time to time. [Quoted] Any help is greatly appreciated.

TIA
Rathan Received on Tue Apr 11 2000 - 05:03:03 CEST