Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

DBMS_REPCAT.DEFINE_PRIORITY_GROUP

Purpose

To create a new priority group for a replicated object group. You must call this procedure from the master definition site. For additional information, refer to [*].

Syntax

The parameters for the DEFINE_PRIORITY_GROUP procedure are described in Table 12 - 111, and the exceptions are listed in Table 12 - 112. The syntax for this procedure is shown below:

DBMS_REPCAT.DEFINE_PRIORITY_GROUP(
			gname		IN	VARCHAR2, 
			pgroup		IN	VARCHAR2, 
			datatype	IN	VARCHAR2, 
			fixed_length	IN	INTEGER := NULL,
			comment	IN	VARCHAR2 := NULL)

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.
datatype The datatype of the priority group members. The datatypes supported are: CHAR, VARCHAR2, NUMBER, DATE, and RAW.
fixed_length You must provide a column length for the CHAR datatype. All other types can use the default, NULL.
comment This user comment is added to the RepPriority view.
Table 12 - 111. Parameters for DEFINE_PRIORITY_GROUP

Exception Description
nonmasterdef The invocation site is not the masterdef site.
missingrepgroup The given replicated object group does not exist.
duplicateprioritygroup The given priority group already exists in the replicated object group.
typefailure The given datatype is not supported.
Table 12 - 112. Exceptions for DEFINE_PRIORITY_GROUP

Contents Index Home Previous Next