Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE

Purpose

To generate the packages needed to support replication for a given table at all master sites. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the GENERATE_REPLICATION_PACKAGE procedure are described in Table 12 - 143, and the exceptions are listed in Table 12 - 144. The syntax for this procedure is shown below:

DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE(
		sname 			IN 	VARCHAR2, 
		oname 			IN 	VARCHAR2)

Parameter Description
sname The schema in which the table is located.
oname The name of the table for which you are generating replication support.

Table 12 - 143. Parameters for GENERATE_REPLICATION_PACKAGE

Exception Description
nonmasterdef The invocation site is not the master definition site.
missingobject The given object does not exist as a table in the given schema awaiting row-level replication information or as a procedure or package (body) awaiting wrapper generation.
commfailure At least one master site is not accessible.
notcompat This procedure requires release 7.3 or greater.
notquiesced The replicated object group was not quiesced.

Table 12 - 144. Exceptions for GENERATE_REPLICATION_PACKAGE

Parameter	Description
`sname`	The schema in which the table is located.
`oname`	The name of the table for which you are generating replication support.

Exception	Description
nonmasterdef	The invocation site is not the master definition site.
missingobject	The given object does not exist as a table in the given schema awaiting row-level replication information or as a procedure or package (body) awaiting wrapper generation.
commfailure	At least one master site is not accessible.
notcompat	This procedure requires release 7.3 or greater.
notquiesced	The replicated object group was not quiesced.