Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.COMMENT_ON_REPSITES

Purpose

To update the comment field in the RepSite view for a replicated site. For additional information, refer to

. This procedure must be issued at the master definition site.

Syntax

The parameters for the COMMENT_ON_REPGROUP procedure are described in Table 12 - 94, and the exceptions are listed in Table 12 - 95. The syntax for this procedure is shown below:

DBMS_REPCAT.COMMENT_ON_REPSITES( 
                           gname   IN VARCHAR2, 
                           master  IN VARCHAR, 
                           comment IN VARCHAR2)

Parameter Description
gname The name of the object group. This avoids confusion if a database is a master site in more than one replicated environment.
master The fully qualified database name of the master site that you want to comment on.
comment The text of the updated comment that you want to include in the MASTER_COMMENT field of the RepSites view.

Table 12 - 94. Parameters for COMMENT_ON_REPSITES

Exception Description
nonmasterdef The invocation site is not the master definition site.

Table 12 - 95. Exceptions for COMMENT_ON_REPSITES

Parameter	Description
`gname`	The name of the object group. This avoids confusion if a database is a master site in more than one replicated environment.
`master`	The fully qualified database name of the master site that you want to comment on.
`comment`	The text of the updated comment that you want to include in the MASTER_COMMENT field of the RepSites view.

Exception	Description
nonmasterdef	The invocation site is not the master definition site.