ansaurus

Question

How to determine ORACLE_HOME from PL/SQL?

Answer 1

+1 A:

Check the last postings on this page:

http://www.mydatabasesupport.com/forums/database-discussions/34933-query-oracle_home-3.html

Bruno Rothgiesser 2009-06-19 13:45:39

Thanks, I used the proposed approach to fetch the path of the `DBMS_SUMADV_LIB` library, which works fine on 10g as well. // Could you edit your answer and actually list the approaches to help other people who find this question?

Jens Bannmann 2009-06-19 14:18:48

Answer 2

+3 A:

DECLARE
 RetVal VARCHAR2(100);
BEGIN
  dbms_system.get_env('ORACLE_HOME', RetVal);
  dbms_output.put_line(RetVal);
END;

NOTE: It is likely you that you will not have permission to this package by default.

Brian 2009-06-19 13:48:24

Unfortunately, on my database, `DBMS_SYSTEM` is not installed.

Jens Bannmann 2009-06-19 14:14:01

Have you considered using a DIRECTORY?CREATE OR REPLACE DIRECTORY APP_ORACLE_HOME AS '/u01/oracle/10.1.2';

Brian 2009-07-06 01:57:57

ansaurus

tags:

views:

answers:

How to determine ORACLE_HOME from PL/SQL?

related questions