Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_DEFER_SYS.DISABLED

Purpose

To determine if propagation of the deferred transaction queue from the current site to a given site is enabled. The DISABLED function returns TRUE if the deferred remote procedure call (RPC) queue is disabled for the given destination. For additional information, refer to

Syntax

The parameter for the DISABLED function is described in Table 12 - 20, the return values are described in Table 12 - 21, and the exception is listed in Table 12 - 22. The syntax for this function is shown below:

DBMS_DEFER_SYS.DISABLED(destination  IN  VARCHAR2)
     RETURN BOOLEAN

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

Table 12 - 20. Parameter for DISABLED

Value Description
TRUE Propagation to this site from the current site is disabled.
FALSE Propagation to this site from the current site is enabled.
Exception Description
NO_DATA_FOUND DESTINATION does not appear in the DefSchedule view.

Table 12 - 22. Exception for DISABLED

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

Value	Description
TRUE	Propagation to this site from the current site is disabled.
FALSE	Propagation to this site from the current site is enabled.
Exception	Description
NO_DATA_FOUND	DESTINATION does not appear in the DefSchedule view.