SET_COLUMNS procedure

This procedure lets you use an alternate column or group of columns, instead of the primary key, to determine which columns of a table to compare when using row-level replication. You must call this procedure from the master definition site.

See Also: Oracle8i Replication for more information.

Syntax

DBMS_REPCAT.SET_COLUMNS (
   sname           IN    VARCHAR2,
   oname           IN    VARCHAR2,
   { column_list   IN    VARCHAR2
   | column_table  IN    DBMS_UTILITY.NAME_ARRAY } );

Note: This procedure is overloaded. The column_list and column_table parameters are mutually exclusive.

Parameters

Table 8-196 SET_COLUMNS Procedure Parameters

Parameter	Description
sname	Schema in which the table is located.
oname	Name of the table.
column_list	A comma-separated list of the columns in the table that you want to use as a primary key. There must be no white space between entries.
column_table	Instead of a list, you can use a PL/SQL table of type DBMS_UTILITY.NAME_ARRAY to contain the column names. The first column name should be at position 1, the second at position 2, and so on.

Exceptions

Table 8-197 SET_COLUMNS Procedure Exceptions

Exception	Description
nonmasterdef	Invocation site is not the master definition site.
missingobject	Specified object does not exist as a table in the specified schema awaiting row-level replication information.
missingcolumn	At least one column is not in the table.
notquiesced	Replicated master group is not quiescing or quiesced.