GET_PROPERTY

The GET_PROPERTY function can be used to get the value of a member property.

GET_PROPERTY Function

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

Parameters

Parameter	Description
`member_name`	The `DB_UNIQUE_NAME` initialization parameter value of the member to be whose property value is to be fetched.
`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.

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 property value and the return value will indicate the reason for this failure.