Oracle7 Server Distributed Systems Volume II: Replicated Data
DBMS_DEFER_SYS.SET_DISABLED
Purpose
To disable or enable propagation of the deferred transaction queue from the current site to a given destination site. If the disabled parameter is TRUE, the procedure disables propagation to the given destination and future invocations of DBMS_DEFER_SYS.EXECUTE do not push the deferred remote procedure call (RPC) queue. SET_DISABLED affects neither a session already pushing the queue to the given destination nor sessions appending to the queue with DBMS_DEFER. If the disable parameter is FALSE, the procedure enables propagation to the given destination and, although this does not push the queue, it permits future invocations to DBMS_DEFER_SYS.EXECUTE to push the queue to the given destination. Whether the disabled parameter is TRUE or FALSE, a COMMIT is required for the setting to take effect in other sessions.
Syntax
The parameters for the SET_DISABLED procedure are described in Table 12 - 26 and the exception is listed in Table 12 - 27. The syntax for this procedure is shown below:
DBMS_DEFER_SYS.SET_DISABLED(destination IN VARCHAR2,
disabled IN BOOLEAN := TRUE)
Parameter
Description
destination
The fully qualified database name of the node whose propagation status you want to change.
disabled
By default, this parameter disables propagation of the deferred transaction queue from your current site to the given destination. Set this parameter to FALSE to enable propagation.
Table 12 - 26. Parameters for SET_DISABLED
Exception
Description
NO_DATA_FOUND
No entry was found in the DefSchedule view for the given DESTINATION.
