Replication Management API Reference, 60 of 179

ALTER_PRIORITY procedure

This procedure alters the priority level associated with a specified priority group member. You must call this procedure from the master definition site.

See Also:
Oracle8i Replication for more information about conflict resolution methods.

Syntax

DBMS_REPCAT.ALTER_PRIORITY (
   gname            IN   VARCHAR2, 
   pgroup           IN   VARCHAR2, 
   old_priority     IN   NUMBER, 
   new_priority     IN   NUMBER);

Parameters

Table 8-97 ALTER_PRIORITY Procedure Parameters

Parameter	Description
gname	Replicated master group with which the priority group is associated.
pgroup	Name of the priority group containing the priority that you want to alter.
old_priority	Current priority level of the priority group member.
new_priority	New priority level that you want assigned to the priority group member.

Exceptions

Table 8-98 ALTER_PRIORITY Procedure Exceptions

Exception	Description
nonmasterdef	Invocation site is not the master definition site.
duplicatepriority	New priority level already exists in the priority group.
missingrepgroup	Specified replicated master group does not exist.
missingvalue	Value was not registered by a call to `DBMS_REPCAT`.`ADD_PRIORITY_datatype`.
missingprioritygroup	Specified priority group does not exist.
notquiesced	Specified replicated master group is not quiesced.