SET_PROPERTY

The SET_CONFIGURATION_PROPERTY function can be used to set a value for a member configurable property.

SET_PROPERTY Function

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

Parameters

Parameter	Description
member_name	The DB_UNIQUE_NAME initialization parameter value of the member whose configurable property value is to be set.
property_name	The name of the configurable property whose value is to be set.
value	The value to set the specified configurable property to.
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 specified configurable property's value was successfully reset to its default value.
Other	The Data Guard broker was unable to reset the specified configurable property to its default value and the return value will indicate the reason for this failure.