GET_CONFIGURATION_PROPERTY

The GET_CONFIGURATION_PROPERTY function can be used to get the value of a configuration property.

GET_CONFIGURATION_PROPERTY Function

DBMS_DG.GET_CONFIGURATION_PROPERTY (
     property_name        IN VARCHAR2,
     value                OUT VARCHAR2,
     severity             OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;

Parameters

Parameter Description
property_name The name of the configuration property whose value is to be fetched.
value The value of the specified configuration property is returned in this output parameter.
severity The severity associated with the status returned by this function. Severity will be one of the following Oracle error numbers:
  • ORA-0: normal, successful completion
  • ORA-16501: The Oracle Data Guard broker operation failed.
  • ORA-16502: The Oracle Data Guard broker operation succeeded with warnings.

Usage Notes

  • This function returns a binary integer.

Return Values

Error Description
ORA-00000: normal, successful completion

The value of the property was successfully fetched.

Other

The Data Guard broker was unable to fetch the configuration property value and the return value will indicate the reason for this failure.