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 »