Re: Retrieve ORACLE_HOME setting from PL/SQL

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 25 Oct 2004 21:03:00 -0700
Message-ID: <1098763323.478582@yasure>

Holger Baer wrote:

> Stephan Bressler wrote:
>

>>
>>
>> Access wrote:
>>
>>> "Stephan Bressler" <sbresslerx_no_spam_at_arcor.de> wrote in message
>>> news:clicm1$hl1$1_at_news.mch.sbs.de...
>>>
>>>> Hi,
>>>>
>>>> we'd like to retrieve the setting of ORACLE_HOME within a PL/SQL
>>>
>>>
>>>
>>>
>>> Maybe you could try to get it from the file /etc/oratab, based on the
>>> current SID (if your system is Unix) ?
>>>
>>> Matthias
>>
>>
>> Hi,
>>
>> I'd like to get the info from within PL/SQL! Accessing oratab via 
>> utl_file_dir or DIRECTORY would be possible, but IMHO rather ugly.
>> I'd prefer a dictionary view or like.
>>
>> Stephan

>
>
> Maybe you'd care to elaborate why you'd want to do that? I'm having a hard
> time figuring out what good it'd do you.
>
> Cheers,
>
> Holger

Exactly what I was thinking ... who cares? And do you want the value on the server or on the client?

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

Received on Mon Oct 25 2004 - 23:03:00 CDT