Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.ADD_GROUPED_COLUMN

Purpose

To add members to an existing column group. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the ADD_GROUPED_COLUMN procedure are described in Table 12 - 62, and the exceptions are listed in Table 12 - 63. The syntax for this procedure is shown below:

DBMS_REPCAT.ADD_GROUPED_COLUMN(	
			sname,			IN	VARCHAR2,
			oname,			IN	VARCHAR2,
			column_group		IN	VARCHAR2,
			list_of_column_names	IN	VARCHAR2,
						IN	DBMS_REPCAT.VARCHAR2S)

Parameter Description
sname The schema in which the replicated table is located.
oname The name of the replicated table with which the column group is located.
column_group The name of the column group to which you are adding members.
list_of_column_names The names of the columns that you are adding to the designated column group. This can either be a comma-separated list or a PL/SQL table of column names. The PL/SQL table must be of type dbms_repcat.varchar2s. Use the single value `*' to create a column group that contains all of the columns in your table.

Table 12 - 62. Parameters for ADD_GROUPED_COLUMN

Exception Description
nonmasterdef The invocation site is not the masterdef site.
missingobject The given table does not exist.
missinggroup The given column group does not exist.
missingcolumn A given column does not exist in the designated table.
duplicatecolumn The given column is already a member of another column group.
missingschema The given schema does not exist

Table 12 - 63. Exceptions for ADD_GROUPED_COLUMN

Parameter	Description
`sname`	The schema in which the replicated table is located.
`oname`	The name of the replicated table with which the column group is located.
`column_group`	The name of the column group to which you are adding members.
`list_of_column_names`	The names of the columns that you are adding to the designated column group. This can either be a comma-separated list or a PL/SQL table of column names. The PL/SQL table must be of type dbms_repcat.varchar2s. Use the single value `*' to create a column group that contains all of the columns in your table.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
missingobject	The given table does not exist.
missinggroup	The given column group does not exist.
missingcolumn	A given column does not exist in the designated table.
duplicatecolumn	The given column is already a member of another column group.
missingschema	The given schema does not exist