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