Re: Retrieve ORACLE_HOME setting from PL/SQL

From: Stephan Bressler <sbresslerx_no_spam_at_arcor.de>
Date: Mon, 25 Oct 2004 13:56:52 +0200
Message-ID: <clipm4$7vu$1@news.mch.sbs.de>

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 Received on Mon Oct 25 2004 - 06:56:52 CDT