CREATE_VAR Built-in
Description
Creates an empty, unnamed variant. There are two versions of the function,
one for scalars and the other for arrays.
Syntax
FUNCTION CREATE_VAR
(persistence BOOLEAN)
RETURN newvar OLEVAR;
FUNCTION CREATE_VAR
(bounds OLE_SAFEARRAYBOUNDS,
vtype VT_TYPE,
persistence BOOLEAN)
RETURN newvar OLEVAR;
Built-in Type unrestricted function
Returns the created OLE variant.
Parameters
- persistence
-
- Controls the persistence of the variant after its creation. A boolean value
of TRUE establishes the variant as persistent; a value of FALSE establishes
the variant as non-persistent.This is an optional parameter. If not specified,
the default value is non-persistent.
-
-
- bounds
-
- A PL/SQL table that specifies the dimensions to be given to the created
array.For more information about the contents and layout of this parameter
and the type OLE_SAFEARRAYBOUNDS, see ARRAY TYPES FOR OLE SUPPORT.
-
- vtype
-
- The OLE variant type (VT_TYPE) of the elements in the created array. If
the array will contain mixed element types, specify VT_VARIANT.
-
Usage Notes
- The created variant is untyped, unless it is an array -- in which case its
elements have the type you specify.
- The created variant is also without a value. Use the SET_VAR function to
assign an initial value and type to the variant.
- A persistent variant exists across trigger invocations. A non-persistent
variant exists only as long as the trigger that spawned the call runs. See
also DESTROY_VARIANT