Modify a Table Column

Use this API to modify a column in a Table definition.

Name

CDR_PUB_DF_TABLE.ModifyColumn

Signature

PROCEDURE modifyColumn(
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_columns_obj_type
) ;

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 object attributes. Enter values you want to change. For OBJECT_TYPE_RC enter $OBJTYPES$COLUMN.
• PIO_COLUMN (Mandatory) This is a parameter of table type CDR_COLUMNS_OBJ_TYPE that contains object attributes specific to Columns. You can change the Column's name, description and values for the NULLABLEFLAGRC, and SAS_LABEL attributes. Valid values for NULLABLEFLAGRC are $YESNO$YES or $YESNO$NO.