Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

DBMS_REPCAT.DROP_PRIORITY_datatype

Purpose

To drop a member of a priority group by value. You must call this procedure from the master definition site. The procedure that you must call is determined by the datatype of your "priority" column. The available procedures are listed below:

For additional information, refer to [*].

Syntax

The parameters for the DROP_PRIORITY_PROCEDURE_datatype procedure are described in Table 12 - 129, and the exceptions are listed in Table 12 - 130. The syntax for the DROP_PRIORITY_VARCHAR2 procedure is shown below. (The syntax for the remaining DROP_PRIORITY_datatype procedures is identical, except for the datatype of the value.)

DBMS_REPCAT.DROP_PRIORITY_VARCHAR2(	gname	IN	VARCHAR2,
	pgroup	IN	VARCHAR2, 
	value	IN	VARCHAR2)

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.
value The value of the priority group member that you want to remove from the group.
Table 12 - 129. Parameters for DROP_PRIORITY_VARCHAR2

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.
paramtype The value has the incorrect datatype for the priority group.
Table 12 - 130. Exceptions for DROP_PRIORITY_VARCHAR2

Contents Index Home Previous Next