Reorder Columns in a Clinical Data Model Table
Use this API to change the order of columns in a table.
Name
DME_PUB_DF_DATA_MODEL.ReorderColumnInDMTable
Signature
procedure ReorderColumnInDMTable( 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 pi_reorderObjColl IN cdr_reorder_obj_coll x_return_status OUT NOCOPY VARCHAR2 x_msg_count OUT NOCOPY NUMBER x_msg_data OUT NOCOPY VARCHAR2);
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
PI_REORDEROBJCOLL (Mandatory): This is a parameter of type CDR_REORDER_OBJ_COLL, which is based on the CDR_REORDER_OBJ_TYPE type. Pass one set of CDR_REORDER_OBJ_TYPE to CDR_REORDER_OBJ_COLL for each column whose order needs to be changed.
- COMPANY_ID: To get your company ID, use CDR_PUB_DEF_FACTORY_UTILS.GetCompanyId.
- OBJ_ID: Enter the column's object ID.
- OBJ_VER: Enter the column's object version.
- NAMESPACE_OBJ_ID: Enter the table's object ID.
- NAMESPACE_OBJ_VER: Enter the table's object version.
- POSITION: Enter the new position for the column, relative to other columns in the table.
- ENTRY_NUMBER: Enter null.
- OBJECT_VERSION_NUMBER: Enter null.
Parent topic: Create and Modify Clinical Data Models