Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_UTILITY , 9 of 23
This function gets the value of specified init.ora
parameter.
DBMS_UTILITY.GET_PARAMETER_VALUE ( parnam IN VARCHAR2, intval IN OUT BINARY_INTEGER, strval IN OUT VARCHAR2) RETURN BINARY_INTEGER;
Parameter | Description |
---|---|
parnam |
Parameter name. |
intval |
Value of an integer parameter or the value length of a string parameter. |
strval |
Value of a string parameter. |
Return | Description |
---|---|
partyp |
0 if parameter is an integer/boolean parameter 1 if parameter is a string/file parameter |
DECLARE parnam VARCHAR2(256); intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('max_dump_file_size', intval, strval); dbms_output.put('parameter value is: '); IF partyp = 1 THEN dbms_output.put_line(strval); ELSE dbms_output.put_line(intval); END IF; IF partyp = 1 THEN dbms_output.put('parameter value length is: '); dbms_output.put_line(intval); END IF; dbms_output.put('parameter type is: '); IF partyp = 1 THEN dbms_output.put_line('string'); ELSE dbms_output.put_line('integer'); END IF; END;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|