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

There are few ways to do this all the methods that I can think of uses external procedure call from PLSQL.
1- if you are using utl_file_dir in you init.ora file, then you could write the file in that directory and execute a shell script to copy the file to the INT_OUTDIR
2- write a shell script which would return the value to caling procedure.

Tom

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 - 07:09:28 CEST