tailieunhanh - Oracle Built−in Packages- P143

Oracle Built−in Packages- P143: 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 or missing_rows_oname is NULL or badnumber -23366 The max_missing is less than 1 or NULL -23302 Remote site is not accessible -23308 The tables onamel oname2 missing_rows_oname1 or missing_rows_oname2 do not exist nosuchsite -23365 The reference_site comparison_site or missing_rows_site does not name a site Restrictions Note the following restrictions on calling the DIFFERENCES procedure You must create tables and before running this procedure. The columns in table missing_rows_oname1 must match the columns passed to column_list or array_columns exactly. The replication group to which the tables belong must be quiesced. Example For an example of how to use the DIFFERENCES procedure see the example under the RECTIFY procedure. The procedure The DIFFERENCES procedure paves the way for its companion procedure RECTIFY which synchronizes the reference table. Before running the RECTIFY procedure always make sure that the updates to the comparison table will not violate any integrity check or NOT NULL constraints. Note that this procedure does not modify the reference table. Here s the specification PROCEDURE snamel IN VARCHAR2 oname1 IN VARCHAR2 reference_site IN VARCHAR2 sname2 IN VARCHAR2 oname2 IN VARCHAR2 comparison_site IN VARCHAR2 column_list IN VARCHAR2 array_columns IN missing_rows_sname IN VARCHAR2 missing_rows_onamel IN VARCHAR2 missing_rows_oname2 IN VARCHAR2 missing_rows_site IN VARCHAR2 commit_rows IN INTEGER 500 Parameters are summarized in the following table. Name Description snamel Name of schema that owns onamel. onamel Table at reference_site truth table . DBMS_RECTIFIER_DIFF Interface 701 Appendix A What s on the Companion Disk reference_site The global_name of site .