Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.ALTER_PRIORITY

Purpose

To alter the priority level associated with a given priority group member. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the ALTER_PRIORITY procedure are described in Table 12 - 76, and the exceptions are listed in Table 12 - 77. The syntax for this procedure is shown below:

DBMS_REPCAT.ALTER_PRIORITY(
			gname		IN	VARCHAR2, 
			pgroup		IN	VARCHAR2, 
			old_priority	IN	NUMBER, 
			new_priority	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 priority that you want to alter.
old_priority The current priority level of the priority group member.
new_priority The new priority level that you want assigned to the priority group member.

Table 12 - 76. Parameters for ALTER_PRIORITY

Exception Description
nonmasterdef The invocation site is not the masterdef site.
duplicatepriority The new priority level already exists in the priority group.
missingrepgroup The given replicated object group does not exist.
missingvalue The value was not registered by a call to DBMS_REPCAT.ADD_PRIORITY_datatype.

Table 12 - 77. Exceptions for ALTER_PRIORITY

Parameter	Description
`gname`	The replicated object group with which the priority group is associated.
`pgroup`	The name of the priority group containing the priority that you want to alter.
`old_priority`	The current priority level of the priority group member.
`new_priority`	The new priority level that you want assigned to the priority group member.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
duplicatepriority	The new priority level already exists in the priority group.
missingrepgroup	The given replicated object group does not exist.
missingvalue	The value was not registered by a call to DBMS_REPCAT.ADD_PRIORITY_datatype.