How Find ORACLE_HOME
SQL> var OHM varchar2(100);
SQL> EXEC dbms_system.get_env('ORACLE_HOME', :OHM)
BEGIN dbms_system.get_env('ORACLE_HOME', :OHM); END;
*
ERROR at line 1:
ORA-06550: line 1, column 48:
PLS-00103: Encountered the symbol "" when expecting one of the following:
:= . ( % ;
The symbol "" was ignored.
SQL> EXEC dbms_system.get_env('ORACLE_HOME', :OHM);
PL/SQL procedure successfully completed.
SQL> PRINT OHM
OHM
--------------------------------------------------------------------------------
/u03/orauat/db/tech_st/11.1.0
SQL>

No comments:
Post a Comment