Re: Getting Unix environment variable from SQL or PL/SQL

You need to make your SQL text into a unix 'here script'. VARIABLE=ABC
export VARIABLE
sqlplus -s <<EOF
system/manager
select .....where col = '$VARIABLE';
EOF Maverick wrote:

> Hi
>
> Does anyone know how to get Unix environment variables from SQL
> or PL/SQL.
>
> Thank you in advance.
>
> Please send all comments to: mav_at_ghg.net
Received on Mon Feb 01 1999 - 21:03:31 CST