Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.COMMENT_ON_conflicttype_RESOLUTION

Purpose

To update the comment field in the RepResolution view for a conflict resolution routine. The procedure that you need to call is determined by the type of conflict that the routine is used to resolve. These procedures must be issued at the master definition site.

Conflict Type Procedure Name
update COMMENT_ON_UPDATE_RESOLUTION
uniqueness COMMENT_ON_UNIQUE_RESOLUTION
delete COMMENT_ON_DELETE_RESOLUTION

The 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_conflicttype_RESOLUTION procedures are described in Table 12 - 98, and the exceptions are listed in Table 12 - 99.

The syntax for the COMMENT_ON_UPDATE_RESOLUTION procedure is shown below:

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

The syntax for the COMMENT_ON_UNIQUE_RESOLUTION procedure is shown below:

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

The syntax for the COMMENT_ON_DELETE_RESOLUTION procedure is shown below:

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

Parameter Description
sname The name of the schema.
oname The name of the replicated table with which the conflict resolution routine is associated.
column_group The name of the column group with which the update conflict resolution routine is associated.
constraint_name The name of the Unique constraint with which the uniqueness conflict resolution routine is associated.
sequence_no The sequence number of the conflict resolution procedure.
comment The text of the updated comment that you want included in the RESOLUTION_COMMENT field of the RepResolution view.

Table 12 - 98. Parameters for COMMENT_ON_UPDATE/UNIQUE/DELETE_RESOLUTION

Exception Description
nonmasterdef The invocation site is not the master definition site.
missingobject The given procedure does not exist.
missingresolution SEQUENCE_NO or COLUMN_GROUP is not registered.

Table 12 - 99. Exceptions for COMMENT_ON_UPDATE/UNIQUE/DELETE_RESOLUTION

Conflict Type	Procedure Name
update	`COMMENT_ON_UPDATE_RESOLUTION`
uniqueness	`COMMENT_ON_UNIQUE_RESOLUTION`
delete	`COMMENT_ON_DELETE_RESOLUTION`

Parameter	Description
`sname`	The name of the schema.
`oname`	The name of the replicated table with which the conflict resolution routine is associated.
`column_group`	The name of the column group with which the update conflict resolution routine is associated.
`constraint_name`	The name of the Unique constraint with which the uniqueness conflict resolution routine is associated.
`sequence_no`	The sequence number of the conflict resolution procedure.
`comment`	The text of the updated comment that you want included in the RESOLUTION_COMMENT field of the RepResolution view.

Exception	Description
nonmasterdef	The invocation site is not the master definition site.
missingobject	The given procedure does not exist.
missingresolution	SEQUENCE_NO or COLUMN_GROUP is not registered.