Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UNIX shell environment Variable in PL/SQL block.
"Girdhar Shingala" <arunpatel_at_sprint.ca> wrote in message
news:ugfr4.4629$o9.47925_at_newscontent-01.sprint.ca...
> Hi,
> Is there anyway to access Unix shell script variable into PL/SQL Block ?
> like I'm using UTL_FILE and I don't want to hardcode location of file in
> Oracle. I want to get this location from the variable set by Shell script.
I don't know get the location from the vairable of Shell script.
But in <init.ora>, you can set 'utl_file_dir=<...>'. Then it is the default
location in creating file.
>
> Any aternative solutions are most wellcome.
>
> Thanks in advance.
I'm sorry that is not enough answer.
>
> Girdhar Shingala.
>
>
Michael Park,
Bothell, WA
Received on Fri Feb 18 2000 - 13:27:12 CST