Kamran Agayev's Oracle Blog

Oracle Certified Master

Archive for April 23rd, 2010

DBMS_UTILITY.GET_PARAMETER_VALUE

Posted by Kamran Agayev A. on 23rd April 2010

There’re different ways to get the values of the parameter file using PL/SQL. One of them is using DBMS_UTILITY.GET_PARAMETER_VALUE function. In the following example, I print the value of the compatible parameter of the parameter file:

[sourcecode language="css"] 

SQL>set serveroutput on;
 declare
    id number;
    str varchar2(40);
 begin
    id:=dbms_utility.get_parameter_value(‘compatible’,id,str);
    dbms_output.put_line(str);
 end;
 /
SQL>   10.2.0.2.0
PL/SQL procedure successfully completed. [/sourcecode]

Posted in DBA scripts | 2 Comments »