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.