Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Retrieve ORACLE_HOME setting from PL/SQL

Re: Retrieve ORACLE_HOME setting from PL/SQL

From: Access <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Mon, 25 Oct 2004 13:42:18 +0200
Message-ID: <417ce69a$0$1434$ba620e4c@news.skynet.be> 






"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

procedure?


> Any ideas how to do this (without extenal procedures, java)?

>

> TIA


> Stephan




Maybe you could try to get it from the file /etc/oratab, based on the
current SID (if your system is Unix) ?



Matthias
Received on Mon Oct 25 2004 - 06:42:18 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US