Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_DEFER_SYS.UNSCHEDULE_EXECUTION

Purpose

To stop automatic communication from a snapshot or master site to another master site. For additional information, refer to

Syntax

The parameter for the UNSCHEDULE_EXECUTION procedure is described in Table 12 - 28, and the exception is listed in Table 12 - 29. The complete syntax for this procedure is shown below:

DBMS_DEFER_SYS.UNSCHEDULE_EXECUTION(
			dblink	IN	VARCHAR2 NOT NULL)

Parameter Description
dblink Fully qualified pathname to master database site at which you want to unschedule periodic execution of deferred remote procedure calls.

Table 12 - 28. Parameter for UNSCHEDULE_EXECUTION

Exception Description
NO_DATA_FOUND No entry was found in the DefSchedule view for the given DBLINK.

Table 12 - 29. Exception for UNSCHEDULE_EXECUTION

Parameter	Description
`dblink`	Fully qualified pathname to master database site at which you want to unschedule periodic execution of deferred remote procedure calls.

Exception	Description
NO_DATA_FOUND	No entry was found in the DefSchedule view for the given DBLINK.