Oracle Distributed Systems

Name

DBMS_REPCAT.COMMENT_ON_conflicttype_RESOLUTION

Synopsis

You can use the COMMENT_ON_conflicttype_RESOLUTION procedure to add or replace a comment for a given conflict resolution type. You can see this comment in the DBA_REPRESOLUTION data dictionary view. Following are the specifications for the three values of conflicttype (UPDATE, UNIQUE, DELETE):

PROCEDURE DBMS_REPCAT.COMMENT_ON_UPDATE_RESOLUTION
   (sname IN VARCHAR2,
    oname IN VARCHAR2,
    column_group IN VARCHAR2,
    sequence_no IN NUMBER,
    comment IN VARCHAR2);

PROCEDURE DBMS_REPCAT.COMMENT_ON_UNIQUE_RESOLUTION
   (sname IN VARCHAR2,
    oname in VARCHAR2,
    constraint_name IN VARCHAR2,
    sequence_no IN NUMBER,
    comment IN VARCHAR2) ;

PROCEDURE DBMS_REPCAT.COMMENT_ON_DELETE_RESOLUTION
   (sname IN VARCHAR2,
    oname IN VARCHAR2,
    sequence_no IN NUMBER,
    comment IN VARCHAR2) ;

Parameters

Parameter Name	Description
sname	Name of the schema to which object oname belongs
oname	Name of the object
column_group	Name of column group for which conflict resolution method is defined
constraint_name	Name of unique constraint the method resolves (COMMENT_ON_UNIQUE_RESOLUTION only)
sequence_no	Sequence number associated with the resolution method
comment	Comment

Exceptions

Exception Name	Number	Description
missingobject	–23308	Object oname does not exist.
missingresolution	–23343	No resolution method exists for column_group and sequence_no.
nonmasterdef	–23312	Calling site is not the master definition site.

Restrictions

• You must call this procedure from the master definition site.

• After this call, ...