Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.ADD_PRIORITY_datatype

Purpose

To add a member to a priority group. 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. You must call this procedure once for each of the possible values of the "priority" column.

The available procedures are listed below:

ADD_PRIORITY_CHAR

ADD_PRIORITY_VARCHAR2

ADD_PRIORITY_NUMBER

ADD_PRIORITY_DATE

ADD_PRIORITY_RAW

For additional information, refer to

Syntax

The parameters for the ADD_PRIORITY_VARCHAR2 procedure are described in Table 12 - 66, and the exceptions are listed in Table 12 - 67. The syntax for the ADD_PRIORITY_VARCHAR2 procedure is shown below. (The syntax for the remaining ADD_PRIORITY_datatype procedures is identical, except for the datatype of the value.)

DBMS_REPCAT.ADD_PRIORITY_VARCHAR2(
				gname		IN	VARCHAR2, 
				pgroup		IN	VARCHAR2, 
				value		IN	VARCHAR2, 
				priority	IN	NUMBER)

Parameter Description
gname The replicated object group for which you are creating a priority group.
pgroup The name of the priority group that you are creating.
value The value of the priority group member. This would be one of the possible values of the associated "priority" column of a table using this priority group.
priority The priority of this value. The higher the number, the higher the priority.

Table 12 - 66. Parameters for ADD_PRIORITY_datatype

Exception Description
nonmasterdef The invocation site is not the masterdef site.
duplicatevalue The given value already exists in the priority group.
duplicatepriority The given priority already exists in the priority group.
missingrepgroup The given replicated object group does not exist.
missingprioritygroup The given priority group does not exist.
paramtype The given value has the incorrect datatype for the priority group.

Table 12 - 67. Exceptions for ADD_PRIORITY_datatype

Parameter	Description
`gname`	The replicated object group for which you are creating a priority group.
`pgroup`	The name of the priority group that you are creating.
`value`	The value of the priority group member. This would be one of the possible values of the associated "priority" column of a table using this priority group.
`priority`	The priority of this value. The higher the number, the higher the priority.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
duplicatevalue	The given value already exists in the priority group.
duplicatepriority	The given priority already exists in the priority group.
missingrepgroup	The given replicated object group does not exist.
missingprioritygroup	The given priority group does not exist.
paramtype	The given value has the incorrect datatype for the priority group.