Modify a Column in a Clinical Data Model Table

Use this API to modify a column.

Name

DME_PUB_DF_DATA_MODEL.ModifyColumnInDataModelTab

Signature

procedure ModifyColumnInDataModelTab(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_column 		IN OUT NOCOPY cdr_dm_column_obj_type );

Parameters

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

• PIO_NAMING (Mandatory): Enter values for the column. This is a parameter of type CDR_NAMING_VERSION_OBJ_TYPE.
• PIO_COLUMN (Mandatory): This is a parameter of type CDR_DM_COLUMN_OBJ_TYPE. Enter current or modified values for the column as required.