Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.DROP_PRIORITY

Purpose

To drop a member of a priority group by priority level. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the DROP_PRIORITY procedure are described in Table 12 - 125, and the exceptions are listed in Table 12 - 126. The syntax for this procedure is shown below:

DBMS_REPCAT.DROP_PRIORITY(	gname		IN	VARCHAR2,
			pgroup		IN	VARCHAR2, 
			priority_num	IN	NUMBER)

Parameter Description
gname The replicated object group with which the priority group is associated.
pgroup The name of the priority group containing the member that you want to drop.
priority_num The priority level of the priority group member that you want to remove from the group.

Table 12 - 125. Parameters for DROP_PRIORITY

Exception Description
nonmasterdef The invocation site is not the masterdef site.
missingrepgroup The given replicated object group does not exist.
missingprioritygroup The given priority group does not exist.

Table 12 - 126. Exceptions for DROP_PRIORITY

Parameter	Description
`gname`	The replicated object group with which the priority group is associated.
`pgroup`	The name of the priority group containing the member that you want to drop.
`priority_num`	The priority level of the priority group member that you want to remove from the group.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
missingrepgroup	The given replicated object group does not exist.
missingprioritygroup	The given priority group does not exist.