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, etc.
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.