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.
Parent topic: Define and Modify Data Marts