Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

ALTER_PRIORITY_datatype Procedure

This procedure alters the value of a member in a priority group. You must call this procedure from the master definition site. The procedure that you must call is determined by the datatype of your priority column.

See Also:

Chapter 6, "Configure Conflict Resolution" and Oracle Database Advanced Replication for more information about conflict resolution methods

Syntax

DBMS_REPCAT.ALTER_PRIORITY_datatype (
   gname        IN   VARCHAR2, 
   pgroup       IN   VARCHAR2, 
   old_value    IN   datatype, 
   new_value    IN   datatype);

where datatype:

{ NUMBER
| VARCHAR2
| CHAR
| DATE
| RAW
| NCHAR
| NVARCHAR2 }

Parameters

Table 18-25 ALTER_PRIORITY_datatype Procedure Parameters  
Parameter Description
gname

Master group with which the priority group is associated.

pgroup

Name of the priority group containing the value that you want to alter.

old_value

Current value of the priority group member.

new_value

New value that you want assigned to the priority group member.

Exceptions

Table 18-26 ALTER_PRIORITY_datatype Procedure Exceptions  
Exception Description
nonmasterdef

Invocation site is not the master definition site.

duplicatevalue

New value already exists in the priority group.

missingrepgroup

Specified master group does not exist.

missingprioritygroup

Specified priority group does not exist.

missingvalue

Old value does not exist.

paramtype

New value has the incorrect datatype for the priority group.

typefailure

Specified value has the incorrect datatype for the priority group.

notquiesced

Specified master group is not quiesced.