OCollection

The OCollection interface represents Oracle collection types, such as variable-length arrays (VARRAYs) and Nested Tables.

Remarks

A Collection is an ordered group of elements, all of the same type. For example, the students in a class or the grades for each student in a class. Each element has a unique subscript, called an index, that determines its position in the collection.

The Collection type Nested Table is viewed as a table stored in the column of database tables. When retrieved, rows of a Nested Table are given consecutive subscripts starting at 1. Individual rows are accessed using an array-like access.

The Collection type VARRAY is viewed as array stored in the column of database tables. To reference an element in a VARRAY, standard subscripting syntax can be used. For example, Grade(3) references the third element in VARRAY named Grades.

The OCollection provides methods for accessing and manipulating an Oracle collection. Individual elements can be accessed by using a subscript. An OCollection element index starts at 1.

VARRAYs and Nested tables do not support the elements of LOBs, VARRAYs, and Nested tables.

The Oracle collection associated with an OCollection is created in the client side object cache.

Construction and destruction:

OCollection

~OCollection

operator=

Attributes:

BOC
EOC
GetElementType
GetMaxSize
GetSize
GetTableSize

GetType
IsLocator
IsNull
IsOpen
operator==
operator!=

Operations:

Append
Clone
Close
CreateIterator
Delete
DeleteIterator
Exist
GetCurrIterValue

GetValue
InitIterator
IterNext
IterPrev
Open
SetValue
Trim