DISABLED Function

This function determines whether propagation of the deferred transaction queue from the current site to a specified site is enabled. The DISABLED function returns true if the deferred remote procedure call (RPC) queue is disabled for the specified destination.

Syntax

DBMS_DEFER_SYS.DISABLED (
   destination  IN   VARCHAR2)
  RETURN BOOLEAN;

Parameters

Table 14-9 DISABLED Function Parameters

Parameter	Description
destination	The fully qualified database name of the node whose propagation status you want to check.

Returns

Table 14-10 DISABLED Function Return Values

Value	Description
true	Propagation to this site from the current site is disabled.
false	Propagation to this site from the current site is enabled.

Exceptions

Table 14-11 DISABLED Function Exceptions

Exception	Description
NO_DATA_FOUND	Specified `destination` does not appear in the `DEFSCHEDULE` view.