OMBALTER FOLDER

Purpose

Alter the folder by renaming it, and/or reset its properties, and/or adding/removing contained objects..

Prerequisites

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

Syntax

alterUserFolderCommand =  OMBALTER ( FOLDER "QUOTED_STRING" ( [ 
          "renameClause" ] [ SET "setPropertiesClause" [ SET 
          "setReferenceIconSetClause" | UNSET "unsetReferenceIconSetClause" ] | 
          SET "setReferenceIconSetClause" | UNSET "unsetReferenceIconSetClause" 
          ] [ "alterContainedObjects" ] ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     alterContainedObjects =  ( "addContainedObjClause" | 
          "removeContainedObjClause" )+
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     addContainedObjClause =  ADD CONTAINED_OBJECT "containedObjTypeClause" 
          "QUOTED_STRING"
     removeContainedObjClause =  REMOVE CONTAINED_OBJECT 
          "containedObjTypeClause" "QUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )
     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 )

Parameters

alterUserFolderCommand

This command modifies an existing folder.

QUOTED_STRING

Name of the existing folder in single quotes.

renameClause

Rename a folder.

setPropertiesClause

Associate a set of properties with the existing 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.

unsetReferenceIconSetClause

Unset icon set for the folder.

alterContainedObjects

Adds or removes a contained object to/from the folder.

propertyNameList

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

propertyValueList

Comma separated list of property values.

addContainedObjClause

Adds a contained object to the folder.

removeContainedObjClause

Removes a contained object from the folder.

propertyValue

Value of a property.

containedObjTypeClause