../E14406-01.epub /> ../E14406-01.mobi />

OMBCREATE FOLDER

Purpose

To create a folder.

Prerequisites

Should be in the context of a module (Oracle, Non-Oracle, Aplications, Process Flow types) or a folder.

Syntax

createUserFolderCommand =  OMBCREATE ( FOLDER "QUOTED_STRING" [ SET 
          "setPropertiesClause" [ SET "setReferenceIconSetClause" ] | SET 
          "setReferenceIconSetClause" ] ( { "addContainedObjClause" } ) )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     addContainedObjClause =  ADD CONTAINED_OBJECT "containedObjTypeClause" 
          "QUOTED_STRING"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     containedObjTypeClause =  ( TABLE | VIEW | PACKAGE | DIMENSION | 
          MATERIALIZED_VIEW | SEQUENCE | CUBE | DATA_AUDITOR | ADVANCED_QUEUE | 
          QUEUE_TABLE | EXTERNAL_TABLE | VARYING_ARRAY | OBJECT_TYPE | 
          NESTED_TABLE | MAPPING | PLUGGABLE_MAPPING | PROCESS_FLOW_PACKAGE | 
          FUNCTION | TABLE_FUNCTION | PROCEDURE )
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createUserFolderCommand

This command creates a folder

QUOTED_STRING

Name of the folder to be created.

setPropertiesClause

Associate a set of properties with a folder.

propertiesClause

Basic properties for FOLDER:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: NAME
Business name of a Folder 

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of a Folder

setReferenceIconSetClause

Set icon set for the folder module.

addContainedObjClause

This command adds a module object to the folder as a contained object.

propertyNameList

Comma separated list of property names. Property names are unquoted.

propertyValueList

Comma separated list of property values.

containedObjTypeClause

The type of the contained object to be added. Valid object types are: TABLE | VIEW | PACKAGE | DIMENSION | MATERIALIZED_VIEW | SEQUENCE | CUBE | ADVANCED_QUEUE | STREAMS_QUEUE | QUEUE_TABLE | EXTERNAL_TABLE | VARYING_ARRAY | OBJECT_TYPE | NESTED_TABLE | MAPPING | PROCESS_FLOW_PACKAGE | FUNCTION | PROCEDURE.

propertyValue

Value of a property.