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