Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.EXECUTE_DDL

Purpose

To supply DDL that you want to have executed at each master site. You can call this procedure only from the master definition site. For additional information, refer to

Syntax

The parameters for the EXECUTE_DDL procedure are described in Table 12 - 141, and the exceptions are listed in Table 12 - 142. The syntax for this procedure is shown below:

DBMS_REPCAT.EXECUTE_DDL(
		gname		IN	VARCHAR2,
		master_list	IN	VARCHAR2 := NULL, |
		master_table	IN	dbms_utility.dblink_array,
		ddl_text	IN	VARCHAR2)

Note: If the DDL is supplied without specifying a schema, the default schema is the replication administrator's schema. Be sure to specify the schema if it is other than the replication administrator's schema.

Parameter Description
gname The name of the replicated object group.
master_list A comma-separated list of master sites at which you want to execute the supplied DDL. There must be no extra whitespace between site names. The default value, NULL, indicates that the DDL should be executed at all sites, including the master definition site.
master_table A table of master sites at which you want to execute the supplied DDL. The first master should be at offset 1, the second at offset 2, and so on.
ddl_text The DDL that you want to have executed at each of the given master sites.

Table 12 - 141. Parameters for EXECUTE_DDL

Exception Description
nonmasterdef The invocation site is not the master definition site.
nonmaster At least one site is not a master site.
ddlfailure DDL at the master definition site did not succeed.
commfailure At least one master site is not accessible.

Table 12 - 142. Exceptions for EXECUTE_DDL

Parameter	Description
`gname`	The name of the replicated object group.
`master_list`	A comma-separated list of master sites at which you want to execute the supplied DDL. There must be no extra whitespace between site names. The default value, NULL, indicates that the DDL should be executed at all sites, including the master definition site.
`master_table`	A table of master sites at which you want to execute the supplied DDL. The first master should be at offset 1, the second at offset 2, and so on.
`ddl_text`	The DDL that you want to have executed at each of the given master sites.

Exception	Description
nonmasterdef	The invocation site is not the master definition site.
nonmaster	At least one site is not a master site.
ddlfailure	DDL at the master definition site did not succeed.
commfailure	At least one master site is not accessible.