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.
Parent topic: Create and Modify Tables