The GENERATE_REPLICATION_SUPPORT procedure generates support for replicated tables, packages, and package bodies required to support replication of the specified object, which can be a table, procedure, package, or package body. The typical use of GENERATE_REPLICATION_SUPPORT is to regenerate the replication support triggers and procedures after changing a replication group’s mode of propagation.
If the object is a table, GENERATE_REPLICATION_SUPPORT creates the table_name$RT triggers on the table, as well as the table_name$RP and table_name$RR packages at all master sites.
If the object is a procedure, package or package body, GENERATE_REPLICATION_SUPPORT generates the requisite procedure wrappers for it. The name of the wrapper procedure is in the format package_prefixoname for packages and package bodies, and procedure_prefixoname for procedures. If the parameters package_prefix or procedure_prefix are not supplied, the default prefix DEFER_ is used.
The specifications differ for Oracle7 and Oracle8 as follows.
PROCEDURE DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (sname IN VARCHAR2, oname IN VARCHAR2, type IN VARCHAR2, package_prefix IN VARCHAR2 := NULL, procedure_prefix IN VARCHAR2 := NULL, distributed IN BOOLEAN := TRUE, gen_objs_owner IN VARCHAR2 := NULL, gen_rep2_trigger IN BOOLEAN := FALSE);
PROCEDURE DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (sname IN VARCHAR2, oname IN VARCHAR2, type ...