Replication Management API Reference, 69 of 179

COMMENT_ON_REPOBJECT procedure

This procedure updates the comment field in the DBA_REPOBJECT view for a replicated object in a master group. This procedure must be issued at the master definition site.

Syntax

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

Parameters

Table 8-115 COMMENT_ON_REPOBJECT Procedure Parameters

Parameter	Description
sname	Name of the schema in which the object is located.
oname	Name of the object that you want to comment on.
type	Type of the object. The types supported are: `TABLE`, `INDEX`, `SYNONYM`, `TRIGGER`, `VIEW`, `PROCEDURE`, `FUNCTION`, `PACKAGE`, and `PACKAGE` `BODY.`
comment	Text of the updated comment that you want to include in the `OBJECT_COMMENT` field of the `DBA_REPOBJECT` view.

Exceptions

Table 8-116 COMMENT_ON_REPOBJECT Procedure Exceptions

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