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