Name
DBMS_REPCAT.COMMENT_ON_REPGROUP
Synopsis
This procedure adds a new schema comment field to the DBA_REPCAT data dictionary view or changes an existing one. The specifications differ for Oracle7 and Oracle8 as follows.
Oracle7 specification:
PROCEDURE DMBS_REPCAT.COMMENT_ON_REPGROUP
(gname IN VARCHAR2 := '',
comment IN VARCHAR2,
sname IN VARCHAR2 := '');Oracle8 specification:
PROCEDURE DMBS_REPCAT.COMMENT_ON_REPGROUP
(gname IN VARCHAR2,
comment IN VARCHAR2);Parameters
Parameter Name | Description |
|---|---|
gname | Replication group to which comment is added |
comment | Comment |
sname (Oracle7 only) | Schema name (provided for pre-Oracle 7.3 compatibility) |
Exceptions
Exception Name | Number | Description |
|---|---|---|
commfailure | –23317 | Unable to communicate with one or more master sites. |
missinggroup | –23331 | Replication group gname does not exist. |
nonmasterdef | –23312 | Calling site is not master definition site. |
Restrictions
The COMMENT_ON_REPGROUP procedure must be called from the master definition site.