The GET_PARAMETER_VALUE function returns the value of a specified init.ora parameter.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_UTILITY.GET_PARAMETER_VALUE (
parnam IN VARCHAR2,
intval IN OUT BINARY_INTEGER,
strval IN OUT VARCHAR2,
listno IN BINARY_INTEGER DEFAULT 1)
RETURN BINARY_INTEGER;
Parameters
| Parameter | Description |
|---|---|
| parnam | The name of the parameter. |
| intval | The value of an integer parameter or the value length of a string parameter. |
| strval | The value of a string parameter. |
| listno | The list item number. |
Return values
Either of the following parameter types is returned:
0: indicatesINTEGER/BOOLEANparameters.1: indicates string/file parameters.
Considerations
To call this function, you must have the
SELECTprivilege on theV$PARAMETERdynamic view.When you use
DBMS_UTILITY.GET_PARAMETER_VALUE, only the first parameter setting of/dir1is returned ifinit.orais set as follows:utl_file_dir = /dir1 utl_file_dir = /dir2A complete comma-delimited string is returned in the case of the following setting:
utl_file_dir = /dir1, /dir2