OMBLOCK

Purpose

Lock one or more objects. If a list of objects is specified, the objects will be locked one by one in the given order. The command will behave atomically, i.e. if it fails to lock any of the objects in the list, then it will lock none of them.

Prerequisites

No other user should have a lock on any of the objects.

Syntax

parseLockCommand =  OMBLOCK "parseTypeNameList" 
     parseTypeNameList =  "objectType" "QUOTED_STRING" { "," "objectType" 
          "QUOTED_STRING" }
     objectType =  ( ADVANCED_QUEUE | BUSINESS_AREA | CATALOG_FOLDER | 
          COLLECTION | CONNECTOR | CONFIGURATION | DEPLOYMENT | CUBE | DIMENSION
           | EXPERT | EXPERT_MODULE | CT | CT_FOLDER | EXTERNAL_TABLE | 
          FLAT_FILE_MODULE | FLAT_FILE | FUNCTION | TABLE_FUNCTION | 
          GATEWAY_MODULE | BUSINESS_DEFINITION_MODULE | 
          OBIEE_BUSINESS_DEFINITION_MODULE | REGISTERED_FUNCTION | LOCATION | 
          LOGICAL_TABLE | MAPPING | MATERIALIZED_VIEW | OBJECT_TYPE | 
          VARYING_ARRAY | NESTED_TABLE | ORACLE_MODULE | PACKAGE | PROCEDURE | 
          PROCESS_FLOW | PROCESS_FLOW_MODULE | PROCESS_FLOW_PACKAGE | 
          WEB_SERVICE | WEB_SERVICE_PACKAGE | APPLICATION_SERVER_MODULE | 
          PROJECT | ITEM_FOLDER | DRILL_PATH | LIST_OF_VALUES | DRILL_TO_DETAIL 
          | ALTERNATIVE_SORT_ORDER | CONTROL_CENTER | MODULE | SAP_MODULE | 
          CMI_MODULE | SEQUENCE | TABLE | VIEW | CMI_DEFINITION | 
          PLSQL_RECORD_TYPE | "UNQUOTED_STRING" )

Parameters

parseLockCommand

Specify lock command.

parseTypeNameList

Specify the object or the list of objects to be locked.

QUOTED_STRING

Name of the object to be locked. Can be specified as an absolute path or as a path relative to the current context. However, there is the restriction that all objects to be locked must be in the current project.

objectType

Type of the object to be locked.