Name
DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP
Synopsis
The COMMENT_ON_PRIORITY_GROUP procedure allows you to add or replace the comment for a priority group (as seen in the DBA_REPPRIORITY_GROUP data dictionary view). The specifications for Oracle7 and Oracle8 differ as follows.
Oracle7 specification:
PROCEDURE DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP
(gname IN VARCHAR2 := '',
pgroup IN VARCHAR2,
comment IN VARCHAR2,
sname IN VARCHAR2 := '');Oracle8 specification:
PROCEDURE DBMS_REPCAT.COMMENT_ON_PRIORITY_GROUP
(gname IN VARCHAR2 := '',
pgroup IN VARCHAR2,
comment IN VARCHAR2);Parameters
Parameter Name | Description |
|---|---|
gname | Name of the replication group containing the priority group |
pgroup | Name of the priority group |
comment | Comment |
sname (Oracle7only) | Schema name (provided for pre-Oracle 7.3 compatibility) |
Exceptions
Exception Name | Number | Description |
|---|---|---|
missingprioritygroup | –23336 | Priority group pgroup does not exist. |
missingrepgroup | –23373 | Replication group gname does not exist. |
nonmasterdef | –23312 | Calling site is not the master definition site. |
Restrictions
You must call COMMENT_ON_PRIORITY_GROUP from the master definition site.