Modify a Constraint in a Clinical Data Model Table
Use this API to modify an existing constraint.
Name
DME_PUB_DF_DATA_MODEL.ModifyConsInDataModelTab
Signature
procedure ModifyConsInDataModelTab(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_dm_tab_cons_obj_type pi_constraintColumns IN OUT NOCOPY 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): Enter values for the constraint. This is a parameter of type CDR_NAMING_VERSION_OBJ_TYPE.
- PIO_CONSTRAINT(Mandatory): This is a parameter of type CDR_DM_TAB_CONS_OBJ_TYPE. Enter current or modified values for the constraint as required.
- PI_VALS. This is a parameter of type CDR_VALS_COLL that is based on CDR_VAL_OBJ_TYPE type. Enter current or modified values for a check constraint as required.
Parent topic: Create and Modify Clinical Data Models