Modify a Table Constraint

Use this API to modify a Table constraint. You need to check out the Table definition to modify the constraint.

PROCEDURE modifyTableConstraint(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE
,p_commit IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE
,p_validation_level IN NUMBER default CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
, pio_naming IN OUT NOCOPY cdr_naming_version_obj_type
, pio_constraint IN OUT NOCOPY cdr_table_cons_obj_type
, pi_constraintColumns IN cdr_table_concols_list_coll
, pi_vals IN cdr_vals_coll
) ;

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• PIO_NAMING (Mandatory) This is a parameter of table type CDR_NAMING_VERSIONS_OBJ_TYPE that contains CDR Naming Version attributes. Enter values to identify the Table Constraint and enter new values for the attributes you want to modify. Enter $OBJTYPES$TABLECNSTR for OBJECT_TYPE_RC.
• PIO_CONSTRAINT (Mandatory) This is a parameter of table type CDR_TABLE_CONS_OBJ_TYPE. Enter values you want to change. You can change the name, description, and values specific to the constraint type; for example, values for the CHECK constraint. You cannot modify the constraint type.
• PI_CONSTRAINTCOLUMNS (Mandatory) This is a collection of table type CDR_TABLE_CONCOLS_OBJ_TYPE. Identify the table and the table's columns where you want to apply the constraints.
• PI_VALS (Optional) This is a collection of CDR_VAL_OBJ_TYPE that contains the values for a CHECK constraint. It is not relevant to other constraints.