This command validates an repository object. The results are generated in a file in a user defined directory.
In the context of a Oracle Module except when validating Project and Oracle Module. To validate a Project the user needs to be in the Root context. To validate Oracle Module the user needs to be in Project context.
parseValidateCommand = OMBVALIDATE ( ( EXPERT | EXPERT_MODULE | CT |
CT_FOLDER | TABLE | VIEW | SEQUENCE | ORACLE_MODULE | COLLECTION |
MATERIALIZED_VIEW | TRANSPORTABLE_MODULE | BUSINESS_DEFINITION_MODULE
| OBIEE_BUSINESS_DEFINITION_MODULE | DIMENSION | CUBE | DATA_AUDITOR |
MAPPING | REAL_TIME_MAPPING | PROJECT | OBJECT_TYPE | VARYING_ARRAY |
NESTED_TABLE | PACKAGE | FUNCTION | PROCEDURE | TABLE_FUNCTION |
EXTERNAL_TABLE | FLAT_FILE | FLAT_FILE_MODULE | ALTERNATIVE_SORT_ORDER
| LIST_OF_VALUES | DRILL_TO_DETAIL | BUSINESS_AREA | DRILL_PATH |
CATALOG_FOLDER | ITEM_FOLDER | REGISTERED_FUNCTION | LOGICAL_TABLE |
LOCATION | CONNECTOR | CONTROL_CENTER | CONFIGURATION | DEPLOYMENT |
PROCESS_FLOW_MODULE | PROCESS_FLOW | PROCESS_FLOW_PACKAGE |
ADVANCED_QUEUE | QUEUE_TABLE | QUEUE_PROPAGATION | PLSQL_RECORD_TYPE |
PLSQL_TABLE_TYPE | PLSQL_REF_CURSOR_TYPE | CALENDAR | CALENDAR_MODULE
| FOLDER | WEB_SERVICE | APPLICATION_SERVER_MODULE |
WEB_SERVICE_PACKAGE ) "QUOTED_STRING" [ "getOutputValidationResults" ]
)
getOutputValidationResults = OUTPUT [ VALIDATION_RESULT ] TO (
"QUOTED_STRING" | ( FILE "QUOTED_STRING" ) ) WRITE ( ( "(" ( ( SUCCESS
| WARNING | ERROR ) [ "," ] )+ ")" ) | ALL | SUCCESS | WARNING |
ERROR )