Element Type Definition: ORACLE_COLLECTION

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	ORACLE_COLLECTION_TYPE
Short Name	OCT
View Name	CI_ORACLE_COLLECTION_TYPES
Description	Definition of a VARRAY or a nested table (specific to Oracle8)

Sub-type of	ORACLE_TYPE
Versioning:	Structure of ORACLE_COLLECTION_TYPE versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	Oracle Designer
Underlying table:	SDD_ORT
Changes:	Summary of changes to ORACLE_COLLECTION_TYPE in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
ORACLE_OBJECT_TYPE_REFERENCE	Y	Prompt: Object Datatype	May be of datatype of one and only one ORACLE_OBJECT_TYPE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
COLLECTION_OF	VARCHAR2(6)	N	Indicates whether collection contains scalars or objects Prompt: Collection of Uppercase	SCALAR_OR_OBJECT	SCALAR
COLLECTION_TYPE	VARCHAR2(12)	N	Indicates the collection type, ie a VARRAY or a nested table Prompt: Collection Type Uppercase	ORACLE_COLLECTION_TYPE	NESTED TABLE
NAME	VARCHAR2(30)	N	Name by which the Oracle type is identified Prompt: Name Uppercase Defined on ORT supertype
OBJECT_REF_FLAG	VARCHAR2(1)	N	Indicates whether this is a collection of REF's Prompt: REF ? Uppercase	YESNO	N
ORT_TYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal property indicating whether the ORACLE_TYPE is an ORACLE_OBJECT_TYPE or an ORACLE_COLLECTION_TYPE Not displayed Uppercase System maintained Not updatable by user Defined on ORT supertype	ORACLE_TYPE_SUBTYPE
REMARK	VARCHAR2(2000)	Y	A comment on the Oracle Type Prompt: Comment Defined on ORT supertype
SCALAR_DATATYPE	VARCHAR2(35)	Y	Datatype of elements in the collection, if COLLECTION_OF = SCALAR Prompt: Scalar Datatype Uppercase	DATATYPE
SCALAR_DECIMAL_PLACES	NUMBER(4, 0)	Y	Decimal places on elements in the collection, if COLLECTION_TYPE = SCALAR Prompt: Scalar Decimal Places
SCALAR_MAXIMUM_LENGTH	NUMBER(5, 0)	Y	Maximum length of elements in the collection, if COLLECTION_OF = SCALAR Prompt: Scalar Maximum Length
VARRAY_LIMIT	NUMBER(6, 0)	Y	The size of the VARRAY, which must be specified when COLLECTION_TYPE = VARRAY Prompt: VARRAY Limit

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC Defined on ORT supertype	Description
NOTES	CDINOT Defined on ORT supertype	Notes

Other Properties
ORACLE_COLLECTION_TYPE has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility
The following 'standard' properties are also inherited by all element types: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference ORACLE_COLLECTION_TYPE:

Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each MODULE_ARGUMENT may be defined by one and only one ORACLE_TYPE (in arc)
Each COLUMN may be referencing or embedding one and only one ORACLE_TYPE
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each DATASTRUCTURE_ITEM may be defined by one and only one ORACLE_TYPE (in arc)
Each PROGRAM_DATUM may be defined by one and only one ORACLE_TYPE (in arc)
Each PLSQL_MODULE may be of return type defined by one and only one ORACLE_TYPE
Each QUEUE_TABLE_DEFINITION may be referencing one and only one ORACLE_TYPE
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each SERVER_OBJECT_USAGE must be for generation of one and only one CIELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype