21 OCI Any Type and Data Functions

This chapter describes the OCI Any Type and Data functions.

See Also:

For code examples, see the demonstration programs included with your Oracle installation. For additional information, refer to Appendix B, "OCI Demonstration Programs".

This chapter contains these topics:

Introduction to Any Type and Data Interfaces

This chapter describes the OCI Any Type and Data functions in detail.

Conventions for OCI Functions

The entries for each function contain the following information:


A brief statement of the purpose of the function.


The function declaration.


A description of each of the function parameters. This includes the parameter's mode. The mode of a parameter has three possible values, as described next:

Table 21-1 Mode of a Parameter

Mode Description


A parameter that passes data to the OCI


A parameter that receives data from the OCI on this call


A parameter that passes data on the call and receives data on the return from this or a subsequent call.


Detailed information about the function if available. This may include restrictions on the use of the function, or other information that might be useful when using the function in an application. An optional section.

All the functions in this chapter are related to each other.

Function Return Values

The OCI Any Type and Data functions typically return one of the following values:

Table 21-2 Function Return Values

Return Value Meaning


The operation succeeded


The operation failed. The specific error can be retrieved by calling OCIErrorGet() on the error handle passed to the function.


The OCI handle passed to the function is invalid.

See Also:

For more information about return codes and error handling, see the section "Error Handling in OCI"