OCITypeSetCollection()

Purpose

Sets collection type information. This call can be made only if the type has been constructed with a collection typecode.

Syntax

sword OCITypeSetCollection ( OCISvcCtx   *svchp, 
                             OCIError    *errhp, 
                             OCIType     *type, 
                             OCIParam    *collelem_info,
                             ub4         coll_count );

Parameters

svchp (IN)

The OCI service context.

errhp (IN/OUT)

The OCI error handle. If there is an error, it is recorded in err and this function returns OCI_ERROR. Obtain diagnostic information by calling OCIErrorGet().

type (IN/OUT)

The type descriptor that is being constructed.

collelem_info (IN)

collelem_info provides information about the collection element. It is obtained by allocating an OCIParam parameter handle and setting type information in the OCIParam using OCIAttrSet() calls.

coll_count (IN)

The count of elements in the collection. Pass 0 for a nested table (which is unbounded).

OCI Any Data Interface Functions

This section describes the Any Data Interface functions.

Table 20-3 Any Data Functions  

Function/Page	Purpose
OCIAnyDataAccess()	Retrieves the data value of an OCIAnyData.
OCIAnyDataAttrGet()	Gets the value of the attribute at the current position in the OCIAnyData.
OCIAnyDataAttrSet()	Sets the attribute at the current position with a given value.
OCIAnyDataBeginCreate()	Allocates an OCIAnyData for the given duration and initializes it with the type information.
OCIAnyDataCollAddElem()	Adds the next collection element to the collection attribute of the OCIAnyData at the current attribute position.
OCIAnyDataCollGetElem()	Accesses sequentially the elements in the collection attribute at the current position in the OCIAnyData.
OCIAnyDataConvert()	Constructs an OCIAnyData with the given data value which will be of the given type.
OCIAnyDataDestroy()	Frees an AnyData .
OCIAnyDataEndCreate()	Marks the end of OCIAnyData creation.
OCIAnyDataGetCurrAttrNum()	Returns the current attribute number of the OCIAnyData.
OCIAnyDataGetType()	Gets the type corresponding to an AnyData value.
OCIAnyDataIsNull()	Checks if OCIAnyData is NULL.
OCIAnyDataTypeCodeToSqlt()	Converts the OCITypeCode for an AnyData value to the SQLT code that corresponds to the representation of the value as returned by the OCIAnyData API.