Oracle Distributed Systems

Name

DBMS_REPCAT.DROP_PRIORITY_datatype

Synopsis

The DROP_PRIORITY_datatype procedure removes a value from a priority group. In this version of the procedure, you can specify the value by data value. The removal of a priority and value takes effect immediately.

The specifications differ for Oracle7 and Oracle 8 as follows.

Oracle7 specification:

PROCEDURE DBMS_REPCAT.DROP_PRIORITY_datatype
	(gname  IN VARCHAR2 := '',
	 pgroup IN VARCHAR2,
	 value  IN {CHAR|VARCHAR2|NUMBER|DATE|RAW},
	 sname  IN VARCHAR2 := '');

Oracle8 specification:

PROCEDURE DBMS_REPCAT.DROP_PRIORITY_datatype
	(name   IN VARCHAR2 := '',
	 pgroup IN VARCHAR2,
	 value  IN {CHAR|NCHAR|VARCHAR2|NUMBER|DATE|RAW},
	 sname  IN VARCHAR2 := '');

datatype and value can be any of the types in the following table.

Oracle7 and Oracle8	Oracle8 Only
CHAR	NCHAR
VARCHAR2	NVARCHAR2
NUMBER
DATE
RAW

Parameters

Parameter Name	Description
gname	Name of the replication group to which priority group pgroup belongs
pgroup	Priority group to which new value and priority are being added
value	Literal value that is being assigned to pgroup
sname (Oracle7 only)	Schema name (provided for pre-Oracle 7.3 compatibility)

Exceptions

Exception Name	Number	Description
missingprioritygroup	–23336	Priority group pgroup does not exist.
missingrepgroup	–23373	Replication group gname does not exist.
nonmasterdef	–23312	Calling site is not the master definition site.
paramtype	–23325	Datatype of value is not the same as the datatype for priority group pgroup.

Restrictions

You must call DROP_PRIORITY_datatype from the ...