Oracle Built−in Packages- P152: 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 new_priority 35 END And querying the DBA_REPPRIORITY data dictionary view again we see the changed data shown here in boldface SQL SELECT gname 2 priority_group 3 varchar2_value site_name 4 priority 5 FROM dba_reppriority 6 WHERE priority_group SP_NORTH_AMERICA 7 ORDER BY priority GNAME PRIORITY GROUP SITE NAME PRIORITY SPROCKET SP_NORTH_AMERICA 10 SPROCKET SP_NORTH_AMERICA Ë33ROCKET SP_NORTH_AMERICA D7NY SPROCKET SP_NORTH_AMERICA 40 This shows with its new and higher priority. The The ALTER_SITE_PRIORITY_SITE procedure is analogous to the datatype procedure use it to change the site name for an existing named site in a site priority group. The specifications for Oracle7 and Oracle8 differ as follows. Here is the Oracle7 specification PROCEDURE gname IN VARCHAR2 name IN VARCHAR2 old_site IN VARCHAR2 new_site IN VARCHAR2 sname IN VARCHAR2 Here is the Oracle8 specification PROCEDURE gname IN VARCHAR2 name IN VARCHAR2 old_site IN VARCHAR2 new_site IN VARCHAR2 Parameters are summarized in the following table Name Description gname Name of the replication group to which the site priority group name belongs name Name of the site priority group old_site Global name of the site currently associated with the priority level new_site Global name of the site that is to replace old_site at old_site s priority level sname Oracle7 only Not used Maintaining Site Priorities 746 Appendix A What s on the Companion Disk Exceptions The ALTER_SITE_PRIORITY_SITE procedure may raise the following exceptions Name Number Description duplicatesite -1 new_site is already in the site priority group missingpriority -1403 Site priority group name does not exist missingrepgroup -23373 Replication group gname does not exist .
