Re: Accessing Environment variables

Michael wrote:
>
> From within a Unix environment, I was hoping to access the value of
> $ORACLE_HOME and other environment variables, but I can't remember how
> to do it...

For PL*SQL, you could try passing the environment variable via the command line if it's appropriate, like:

sqlplus username/password _at_my_sql.sql $ORACLE_HOME

and then reference the variable &1 from the code my_sql.sql .

To test it, create a small SQL file containing "select '&1' from dual;exit;".

Don't know about Reports though.

Jamie Keir Received on Wed Jul 16 1997 - 00:00:00 CEST