Name
DBMS_REPCAT.ALTER_PRIORITY_datatype
Synopsis
The ALTER_PRIORITY_datatype procedures let you alter the data value associated with a specific priority for a priority group. For example, in the priority group PG_MFG_STAT, the value associated with priority 1 could be changed from CONCEPT to PLANNED. The change takes effect immediately. The specifications differ for Oracle7 and Oracle8 as follows.
Oracle7 specification:
PROCEDURE DBMS_REPCAT.ALTER_PRIORITY_datatype
(gname IN VARCHAR2 := '',
pgroup IN VARCHAR2,
old_value IN {CHAR|VARCHAR2|NUMBER|DATE|RAW},
new_value IN {CHAR|VARCHAR2|NUMBER|DATE|RAW},
sname IN VARCHAR2 := '');
Oracle8 specification:
PROCEDURE DBMS_REPCAT.ALTER_PRIORITY_datatype
(gname IN VARCHAR2 := '',
pgroup IN VARCHAR2,
old_value IN {CHAR|NCHAR|VARCHAR2|NUMBER|DATE|RAW},
new_value IN {CHAR|NCHAR|VARCHAR2|NUMBER|DATE|RAW});
datatype, value, and old_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 | Name of the priority group whose priority is being altered |
old_value | Current value of the priority group member |
new_value | New value of the priority group member |
sname (Oracle7 only) | Schema name (provided for pre-Oracle 7.3 compatibility) |
Exceptions
Exception Name | Number | Description |
---|---|---|
duplicatevalue | –23338 | Value new_value is already designated a priority in priority group pgroup. |
missingprioritygroup | –23336 ... |
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.