SafeArray (OraCollection) Property

Applies To

OraCollection Object

Description

Gets or sets the element values from the Variant SAFEARRAY.

Usage

SafeArray = OraCollection.SafeArray

OraCollection.SafeArray = SafeArray

Arguments

SafeArray - A variant representing SafeArray format.

Remarks

This property is only valid for simple scalar elements types, such as VARCHAR2 and NUMBER. This property will raise an error for element type of LOBS, Objects, Refs, and so on.

The Variant SAFEARRAY index starts at 0. When converting to SAFEARRAY format, OraCollection converts its element value to its corresponding SAFEARRAY Variant type. The following table explains collection element types and corresponding SAFEARRAY Variant types:

Collection Element Type	SAFEARRAY of
Date	String
Number	String
CHAR,VARCHAR2	String
Real	Real
Integer	Integer

For setting a SAFEARRAY to a collection, OraCollection converts the SAFEARRAY elements to its nearest collection element type.

Data Type

A Variant representing a SafeArray format.