Modify a Data Mart

Use this API to modify a Data Mart definition or instance. You can modify the name and description. If you are modifying an instance object, you can also change the 3 REF attribute values to select a different source definition.

Note: If you are modifying a definition, you must first check it out.

Name

CDR_PUB_DF_DATAMART.ModifyDataMart

Signature

PROCEDURE MODIFYDATAMART( 
  P_API_VERSION  IN    NUMBER, 
  P_INIT_MSG_LIST  IN    VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, 
  P_COMMIT  IN    VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, 
  P_VALIDATION_LEVEL  IN    NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, 
  X_RETURN_STATUS  OUT    VARCHAR2, 
  X_MSG_COUNT  OUT    NUMBER, 
  X_MSG_DATA  OUT    VARCHAR2, 
  PIO_CDRNAMING  IN OUT    CDR_NAMING_VERSION_OBJ_TYPE 
); 

Parameters

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

PIO_CDRNAMING (Mandatory) This is a parameter of table type CDR_NAMING_VERSION_OBJ_TYPE. Enter values to identify the Data Mart and enter new values for the attributes you want to modify. You can change the name or description for either a definition or instance. For an instance you can also change to a different underlying source definition by entering values for the new definition in the three REF attributes. All attributes are required.

NOTE: Use separate APIs for modifying the validation status and the version label: CDR_PUB_VL_VALIDATION. UpdateValStatus and CDR_PUB_DF_NAMING. UpdateVersionLabel.