Oracle Built−in Packages- P150: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk VARCHAR2 NUMBER DATE RAW NCHAR Oracle8 only NVARCHAR2 Oracle8 only Parameters are summarized in the following table. 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 added to pgroup sname Oracle only Not used Exceptions The DROP_PRIORITY_ datatype procedure may raise the following exceptions 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 master definition site. Example You can specify the member to be dropped by its data value rather than its priority as was done with DROP_PRIORITY . In the following example we drop the member of the PG_PRODUCTION_STATUS priority group whose value is CONCEPT BEGIN gname SPROCKET pgroup PG_PRODUCTION_STATUS value CONCEPT END As with DROP_PRIORITY this change takes effect after has been run for any object in the replication group. PREVIOUS Column Groups with DBMS_REPCAT . Orode PL SQL Orode PL SQL orT Programming. I Programming Mne Second Edition Guide to Oradeti Features HOME HEXT book index Site Priority Groups with DBMS_REPCAT Orode Advanced Pl SOL Orode Wei Applications Orode PL SQL Orode Pl SOL Budlin I Progrommng I PL SQL Developer s I Latgvoge I Budt-ins Packages wrtii Packages Introduction Pocket Reference Pocket Reference Dropping Priorities from a Priority Group 736 Appendix A What s on the Companion Disk Copyright c 2000 O Reilly Associates. All rights reserved. Dropping Priorities
