Re: query $ORACLE_HOME

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 18 Nov 2004 08:12:32 -0800
Message-ID: <1100794268.662016@yasure>

Connor McDonald wrote:

> robert wrote:
> 

>>Connor McDonald wrote:
>>
>>>check dbms_system
>>
>>hmm why I dont have dbms_system ?
>>
>>Connected to:
>>Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
>>With the Partitioning, OLAP and Data Mining options
>>
>>SQL> select user from dual;
>>
>>USER
>>------------------------------
>>SYSTEM
>>
>>SQL> desc dbms_system
>>ERROR:
>>ORA-04043: object dbms_system does not exist

> 
> 
> SQL> declare
>   2   x varchar2(100);
>   3  begin
>   4    dbms_system.get_env('ORACLE_HOME',x);
>   5    dbms_output.put_line(x);
>   6  end;
>   7  /
> C:\oracle\ora10
> 
> PL/SQL procedure successfully completed.
> 

Does anyone have a list of all of the environment variables that can be obtained using get_env? If so I would appreciate a copy for the PSOUG library: Can't find anything on OTN.

Thanks.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Nov 18 2004 - 10:12:32 CST