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, ...