EXECUTE_DDL Procedure

Oracle® Database Advanced Replication Man agement API Reference
10g Release 1 (10.1)
Part Number B10733-01

< /table>

Go to Book List

< br> Book List

Go to Table of Contents

Go to Index

Go to Master Index

Go to Feedback page

Go to previous page

Previous< /font>

Go to current ch
apter

Go to next page

EXECUTE_DDL Proc edure

This procedure supplies DDL that you want to have executed at some or all maste r sites. You can call this procedure only from the master definition site.

Syntax

DBMS_REPCAT.EXECUTE_DDL (
   gname           IN   VARCHAR2,
   { master_list   IN   VARCHAR2     := NULL, 
 |
 master_table  IN   DBMS_UTILITY.DBLINK_ARRAY,}
   DDL_TEXT        IN   VARCHAR2);

< div align="center">

Parameters

Table 18-94 EXECUTE_DDL Proc edure Parameters

< font face="Arial, Helvetica, sans-serif">Note:

This procedure is overloaded. The master_list and master_table parameters are mutually exclusive.

Parameter	Description
gname	Name of the master group.
master_list	A comma-delimited list of master sites at which you want to execute the supplied DDL. Do not put any s paces 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 that lists the master sites where yo u want to execute the supplied DDL. The first master should be at position 1, the second at position 2, and so on.
ddl_text	The DDL that you want to execute at each of the specified master sites. If the DDL is suppl ied without specifying a schema, then 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.

Exceptions

< strong>Table 18-95 EXECUTE_DDL Procedure Exceptions

Exception Description

nonmasterdef

Invocation site is not the master definition site.

nonmaster

At least one site is not a master site.

ddlfailure

DDL at the mas ter definition site did not succeed.

commfailure

At least one master site is not accessible.