tailieunhanh - Oracle Built−in Packages- P136

Oracle Built−in Packages- P136: 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 distributed IN BOOLEAN TRUE gen_objs_owner IN VARCHAR2 NULL min_communication IN BOOLEAN TRUE Parameters are summarized in the following table. Name Description sname Name of the schema to which table oname belongs. oname Name of table for which package is being generated. type Object type. Supported types TABLE PROCEDURE PACKAGE and PACKAGE BODY. package_prefix Prefix used to name generated wrapper package for packages and package bodies. procedure_prefix Prefix used to name generated wrapper package for procedures. distributed If TRUE the default generate replication support for the object at each master if FALSE copy the reapplication support objects generated at the master definition site. gen_objs_owner Specifies schema in which to generate replication support objects if NULL the default objects are generated under schema sname. gen_rep2_trigger Oracle7 only Provided for backward compatibility if any masters are releases this must be set to TRUE. The default is FALSE. min_communication Oracle8 only If TRUE the default Oracle propagates changes with the minimum communication parameter which avoids sending the old and new column values of unmodified fields. Exceptions The GENERATE_REPLICATION_SUPPORT procedure may raise the following exceptions Name Number Description commfailure -23317 Unable to communicate with all masters dbnotcompatible -23375 One or more masters is a release missingobject -23308 Table oname does not exist in schema sname missingschema -23306 Schema sname does not exist nonmasterdef -23312 Calling site is not a master definition site notquiesced -23310 Replication group to which object belongs is not quiesced typefailure -23319 Specified type is not a supported type Restrictions Note the following restrictions on calling GENERATE_REPLICATION_SUPPORT You must call this procedure from the master definition site for each object in the replication group. The .