Applies To
OraParamArrayDescription
Returns the value of a particular element of the array at the specified index.
Arguments
[in] array
A String representing the name of the array.
[in] index
An Integer representing the index value of the object.
Usage
OraParamArray.Get_Value(array, index)
Remarks
OraParamArray.Get_Value returns the value of the field as a variant. data_value = oraparameter.Value sets the contents of the parameter.
Note that fields of type DATE are returned in the default Visual Basic format
as specified in the control panel, even though the default Oracle date format
is "DD-MMM-YY".
The Value argument can be an Oracle8i object, such as an OraBLOB. For put_value a copy of the object is made at that point in time and get_value must be accessed to
obtain a new object that refers to that index value. For example, if iotype is ORATYPE_BOTH and an OraBlob obtained from a dynaset is passed in as the
input value, get_value will need to be called after the SQL has been executed so
that the newly updated output value of the ParamaterArray can be obtained.
Similar to a dynaset, the object obtained from ParamaterArray get_value
property always refers to the latest value for that ParamaterArray index. The Visual
Basic value NULL can also be passed as a value. The Visual Basic value EMPTY
can be used for BLOB and CLOB to mean an empty LOB, and for OBJECT, VARRAY and
NESTED TABLE to mean an object whose attributes are all NULL.
This method is not available at design time and is read-only at run time.