Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP/ DBMS_REPCAT.COMMENT_ON_SITE_PRIORITY

Purpose

To update the comment field in the RepPriority_Group view for a priority group. This comment is not added at all master sites until the next call to DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT. For additional information, refer to [*].

To update the comment field in the RepPriority_Group view for a site priority group, call the COMMENT_ON_SITE_PRIORITY procedure in the DBMS_REPCAT package. (This procedure is a wrapper for the COMMENT_ON_COLUMN_GROUP procedure and is provided as a convenience only.) This procedure must be issued at the master definition site.

Syntax

The parameters for the COMMENT_ON_PRIORITY_GROUP and COMMENT_ON_SITE_PRIORITY procedures are described in Table 12 - 90, and the exceptions are listed in Table 12 - 91.

The syntax for the COMMENT_ON_PRIORITY_GROUP procedure is shown below:

DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP(
				gname		IN	VARCHAR2, 
				pgroup		IN	VARCHAR2, 
				comment	IN	VARCHAR2)

The syntax for the COMMENT_ON_SITE_PRIORITY procedure is shown below:

DBMS_REPCAT.COMMENT_ON_SITE_PRIORITY(
				gname		IN	VARCHAR2, 
				name		IN	VARCHAR2, 
				comment	IN	 VARCHAR2)

Parameter Description
gname The name of the replicated object group.
pgroup/name The name of the priority or site priority group.
comment The text of the updated comment that you want included in the PRIORITY_COMMENT field of the RepPriority_Group view.
Table 12 - 90. Parameters for COMMENT_ON_PRIORITY_GROUP and COMMENT_ON_SITE_PRIORITY

Exception Description
nonmasterdef The invocation site is not the master definition site.
missingrepgroup The given replicated object group does not exist.
missingprioritygroup The given priority group does not exist.
missingpriority The given site priority group does not exist.
Table 12 - 91. Exceptions for COMMENT_ON_PRIORITY_GROUP and COMMENT_ON_SITE_PRIORITY


Contents Index Home Previous Next