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

You might find life a lot easier to store configuration variables like this in a table in oracle itself. Then, to get your variable INT_OUTDIR, you can just 'select into' from that table.

HTH AW

RATHANB <rathanb_at_cs.com> wrote in message news:20000410230303.10363.00000789_at_ng-bj1.news.cs.com...
> Hi all
> 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:
> 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?
> If so how, I know that precompilers can be used to do this, but I am
looking to
> refer this dynamic variable into my pl/sql block? Reason is that that
directory
> path could be changed from time to time.
> Any help is greatly appreciated.
>
> TIA
> Rathan
Received on Tue Apr 11 2000 - 13:18:27 CEST