Re: Retrieve ORACLE_HOME setting from PL/SQL

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Mon, 25 Oct 2004 14:27:04 +0200
Message-ID: <clirep$91v$1@news.BelWue.DE>

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 Received on Mon Oct 25 2004 - 07:27:04 CDT