OCI Any Type and Data Functions, 19 of 26

OCIAnyDataTypeCodeToSqlt()

Purpose

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.

Syntax

sword  OCIAnyDataTypeCodeToSqlt ( OCIError       *errhp, 
                                  OCITypeCode    tc,
                                  ub1            *sqltcode,
                                  ub1            *csfrm) ;

Parameters

errhp (IN/OUT)

The OCI error handle. If there is an error, it is recorded in errhp and this function returns OCI_ERROR. Diagnostic information can be obtained by calling OCIErrorGet().

tc (IN)

OCITypeCode corresponding to the AnyData value.

sqltcode (OUT)

SQLT code corresponding to the user format of the typecode.

csfrm (OUT)

Charset form corresponding to the user format of the typecode. Meaningful only for character types. Returns SQLCS_IMPLICIT or SQLCS_NCHAR (for NCHAR types).

Comments

This function converts OCI_TYPECODE_CHAR as well as OCI_TYPECODE_VARCHAR2 to SQLT_VST (which corresponds to the OCIString mapping) with a charset form of SQLCS_IMPLICIT. OCI_TYPECODE_NVARCHAR2 will also return SQLT_VST (OCIString mapping is used by the OCIAnyData API) with a charset form of SQLCS_NCHAR.

See Also:

For more information see "NCHAR Typecodes for OCIAnyData Functions"

OCI Any Data Set Interface Functions

This section describes the Any Data Set Interface functions.

Table 20-4 Any Data Set Functions

Function/Page	Purpose
`OCIAnyDataSetAddInstance()`	Adds a new skeleton instance to the OCIAnyDataSet and all the attributes of the instance are set to NULL.
`OCIAnyDataSetBeginCreate()`	Allocates an OCIAnyDataSet for the given duration and initializes it with the type information.
`OCIAnyDataSetDestroy()`	Frees the OCIAnyDataSet.
`OCIAnyDataSetEndCreate()`	Marks the end of OCIAnyDataSet creation.
`OCIAnyDataSetGetCount()`	Gets the number of instances in the OCIAnyDataSet
`OCIAnyDataSetGetInstance()`	Returns the OCIAnyData corresponding to an instance at the current position and updates the current position.
`OCIAnyDataSetGetType()`	Gets the type corresponding to an OCIAnyDataSet.