OMBRETRIEVE VARYING_ARRAY

Purpose

Retrieve details of the Varying Array.

Prerequisites

Should be in the context of an Oracle Module.

Syntax

retrieveVaryingArrayCommand =  OMBRETRIEVE VARYING_ARRAY "QUOTED_STRING" ( 
          GET ( "getPropertiesClause" | "getReferenceIconSetClause" ) )
     getPropertiesClause =  PROPERTIES "(" "propertyNameList" ")"
     getReferenceIconSetClause =  ( REF | REFERENCE ) ICONSET
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }

Parameters

retrieveVaryingArrayCommand

Retrieves the details of the Varying Array with the given name.

getPropertiesClause

This clause retrieves all the properties.

getPropertiesClause

Basic properties for VARYING_ARRAY: 

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the Varying Array

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

Name: DATATYPE
Type: STRING(20)
Valid Values: BINARY_DOUBLE, BINARY_FLOAT, BLOB, CHAR, CLOB, DATE, FLOAT, INTEGER, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, NCHAR, NCLOB, NUMBER, NVARCHAR2, RAW, SYS.ANYDATA, SYS.LCR$_ROW_RECORD, XMLFORMAT, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE, VARHCAR, VARCHAR2, XMLTYPE
Default: Empty string
Datatype of the Base Element of the Varying Array

getReferenceIconSetClause

Gets reference icon set.

propertyNameList

The list of properties.

VARYING_ARRAY Object

Table 21-13 VARYING_ARRAY Object

Property	Type	Choices	Min	Max	Default	Description
DEPLOYABLE	BOOLEAN	true, false	none	none	true	Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
GENERATION_COMMENTS	STRING	none	none	none	empty string	Enter additional comments for the generated code.

See Also

OMBRETRIEVE