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 ...
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.