Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

DBMS_REPCAT.ALTER_PRIORITY_datatype

Purpose

To alter the value of 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. The available procedures are listed below.

For additional information, refer to [*].

Syntax

The parameters for the ALTER_PRIORITY_VARCHAR2 procedure are described in Table 12 - 78, and the exceptions are listed in Table 12 - 79. The syntax for this procedure is shown below. (The syntax for the remaining ALTER_PRIORITY_datatype procedures is identical, except for the datatype of the old and new values.)

DBMS_REPCAT.ALTER_PRIORITY_VARCHAR2(
				gname		IN	VARCHAR2, 
				pgroup		IN	VARCHAR2, 
				old_value	IN	VARCHAR2, 
				new_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 value that you want to alter.
old_value The current value of the priority group member.
new_value The new value that you want assigned to the priority group member.
Table 12 - 78. Parameters for ALTER_PRIORITY_VARCHAR2

Exception Description
nonmasterdef The invocation site is not the masterdef site.
duplicatevalue The new value already exists in the priority group.
missingrepgroup The given replicated object group does not exist.
missingprioritygroup The given priority group does not exist.
missingvalue The old value does not already exist.
paramtype The new value has the incorrect datatype for the priority group.
Table 12 - 79. Exceptions for ALTER_PRIORITY_VARCHAR2

Contents Index Home Previous Next