Re: Querying environment variables

Radoulov, Dimitre wrote:
> That's your client env, not the server env:

Perhaps, but this is the case only when the client is on the server (and even then, only when the client has specifically overridden the env var value in existence when the instance was started).

...client on windows, server on linux...

O:\>sqlplus howards_at_wcasbld

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 4 10:48:21 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> var f varchar2(40)
SQL> set autop on
SQL> exec sys.dbms_system.get_env('ORACLE_HOME',:f) ;

PL/SQL procedure successfully completed.

F

/u01/app/oracle/product/10.2.0

SQL> $echo %ORACLE_HOME%
c:\oracle\product\10.2.0\db_1

SQL> Regards,

Steve Received on Mon Dec 04 2006 - 09:57:49 CST