Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.COMMENT_ON_COLUMN_GROUP

Purpose

To update the comment field in the RepColumn_Group view for a column 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

Syntax

The parameters for the COMMENT_ON_COLUMN_GROUP procedure are described in Table 12 - 88, and the exceptions are listed in Table 12 - 89. The syntax for this procedure is shown below:

DBMS_REPCAT.COMMENT_ON_COLUMN_GROUP(
				sname		IN	VARCHAR2, 
				oname		IN	VARCHAR2, 
				column_group	IN	VARCHAR2, 
				comment	IN	VARCHAR2)

Parameter Description
sname The name of the schema in which the object is located.
oname The name of the replicated table with which the column group is associated.
column_group The name of the column group.
comment The text of the updated comment that you want included in the GROUP_COMMENT field of the RepColumn_Group view.

Table 12 - 88. Parameters for COMMENT_ON_COLUMN_GROUP

Exception Description
nonmasterdef The invocation site is not the master definition site.
missinggroup The given column group does not exist.

Table 12 - 89. Exceptions for COMMENT_ON_COLUMN_GROUP

Parameter	Description
`sname`	The name of the schema in which the object is located.
`oname`	The name of the replicated table with which the column group is associated.
`column_group`	The name of the column group.
`comment`	The text of the updated comment that you want included in the GROUP_COMMENT field of the RepColumn_Group view.

Exception	Description
nonmasterdef	The invocation site is not the master definition site.
missinggroup	The given column group does not exist.