Oracle7 Server Distributed Systems Volume II: Replicated Data
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