Name
DBMS_REPCAT.DROP_PRIORITY
Synopsis
The DROP_PRIORITY procedure removes a value from a priority group. The change takes effect immediately. The specifications differ for Oracle7 and Oracle8 as follows.
Oracle7 specification:
PROCEDURE DBMS_REPCAT.DROP_PRIORITY (gname IN VARCHAR2 := '', pgroup IN VARCHAR2, priority_num IN NUMBER, sname IN VARCHAR2 := '');
Oracle8 specification:
PROCEDURE DBMS_REPCAT.DROP_PRIORITY (gname IN VARCHAR2 := '', pgroup IN VARCHAR2, priority_num IN NUMBER);
Parameters
Parameter Name | Description |
|---|---|
gname | Name of the replication group to which priority group pgroup belongs |
pgroup | Name of the priority group whose priority is being altered |
priority_num | Priority for the value to be dropped |
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. |
Restrictions
You must call the DROP_PRIORITY procedure from the master definition site.