Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.COMMENT_ON_REPOBJECT

Purpose

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

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

Syntax

The parameters for the COMMENT_ON_REPOBJECT procedure are described in Table 12 - 96, and the exceptions are listed in Table 12 - 97. The syntax for this procedure is shown below:

DBMS_REPCAT.COMMENT_ON_REPOBJECT(	sname	IN	VARCHAR2, 
	oname	IN	VARCHAR2, 
	type	IN	VARCHAR2, 
	comment	IN	VARCHAR2)

Parameter Description
sname The name of the schema in which the object is located.
oname The name of the object that you want to comment on.
type The type of the object.
comment The text of the updated comment that you want to include in the OBJECT_COMMENT field of the RepObject view.

Table 12 - 96. Parameters for COMMENT_ON_REPOBJECT

Exception Description
nonmasterdef The invocation site is not the master definition site.
missingobject The given object does not exist.
typefailure The given type parameter is not supported.
commfailure At least one master site is not accessible.

Table 12 - 97. Exceptions for COMMENT_ON_REPOBJECT

Parameter	Description
`sname`	The name of the schema in which the object is located.
`oname`	The name of the object that you want to comment on.
`type`	The type of the object.
`comment`	The text of the updated comment that you want to include in the OBJECT_COMMENT field of the RepObject view.

Exception	Description
nonmasterdef	The invocation site is not the master definition site.
missingobject	The given object does not exist.
typefailure	The given type parameter is not supported.
commfailure	At least one master site is not accessible.