11gR2 : Error with DBMS_SYSTEM
Hi ,
I have this error when trying to dispaly ORACLE_HOME value . Why ?
DECLARE
folder VARCHAR2 (100);
BEGIN
SYS.DBMS_SYSTEM.get_env('ORACLE_HOME', folder);
DBMS_OUTPUT.put_line (folder);
END;
ORA-06550: line 5, column 4:
PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared
ORA-06550: line 5, column 4:
PL/SQL: Statement ignored
Best regards.
GD.
I have this error when trying to dispaly ORACLE_HOME value . Why ?
DECLARE
folder VARCHAR2 (100);
BEGIN
SYS.DBMS_SYSTEM.get_env('ORACLE_HOME', folder);
DBMS_OUTPUT.put_line (folder);
END;
ORA-06550: line 5, column 4:
PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared
ORA-06550: line 5, column 4:
PL/SQL: Statement ignored
Best regards.
GD.
0