Validate Expression

Use this API to validate user defined map column or criteria expression.

Name

DME_PUB_XFORM_MAP.ValidateExpression

Signature

PROCEDURE VALIDATEEXPRESSION
(P_API_VERSION IN VARCHAR2,  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,  PI_OBJID IN CDR_NAMINGS.OBJ_ID%TYPE,  PI_OBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE,  PI_EXPROBJ IN DME_XFORM_EXPR_OBJ_TYPE
);

Parameters

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

• PI_OBJID (Mandatory). Enter the object Id of the model transformation map in which expression is applied for one of the map entity. In case of Create operations, map will not exist in DB. Pass the table definition id from which column has been selected into the expression. Pass NULL, in case, no column is used in expression text.
• PI_OBJVER (Mandatory). Enter the object Version of the model transformation map or table definition from which column is used in expression. Pass NULL, in case there is no column used in expression.
• PI_EXPROBJ (Mandatory). This parameter is a object type of DME_XFORM_EXPR_OBJ_TYPE. Refer to the following sectionCreate or Modify an Expression, for more details.