OCITypeBeginCreate()

Purpose

Begins the construction process for a transient type. The type will be anonymous (no name).

Syntax

sword OCITypeBeginCreate ( OCISvcCtx    *svchp, 
                           OCIError     *errhp, 
                           OCITypeCode  tc, 
                           OCIDuration  dur, 
                           OCIType      **type );

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().

tc (IN)

The typecode for the type. The typecode could correspond to an object type or a built-in type.

Currently, the permissible values for User Defined Types are:

• OCI_TYPECODE_OBJECT for an Object Type (structured),
• OCI_TYPECODE_VARRAY for a VARRAY collection type or
• OCI_TYPECODE_TABLE for a nested table collection type.

For Object types, call OCITypeAddAttr() to add each of the attribute types. For Collection types, call OCITypeSetCollection(). Subsequently, call OCITypeEndCreate() to finish the creation process.

The permissible values for built-in type codes are specified in "Typecodes". Additional information on built-in types (precision, scale for numbers, character set information for VARCHAR2s, etc.) if any, must be set with a subsequent call to OCITypeSetBuiltin(). Finally, you must use OCITypeEndCreate() to finish the creation process.

dur (IN)

The allocation duration for the type. One of the following:

• A user duration that was previously created. It can be created by using OCIDurationBegin().
• A predefined duration, such as OCI_DURATION_SESSION.

type (OUT)

The OCIType (Type Descriptor) that is being constructed.

Comments

To create a persistent named type, use the SQL statement CREATE TYPE. Transient types have no identity. They are pure values.