What's New

This section summarizes new features and functionality of Oracle TimesTen In-Memory Database 11g Release 2 (11.2.2) that are documented in this guide, providing links into the guide for more information.

New features in Release 11.2.2.4.0

This release of the document provides information about TimesTen support for the ODBC SQLGetInfo and SQLColAttributes functions.

See Chapter 10, "TimesTen ODBC Functions and Options".

New features in Release 11.2.2.2.0

SQLCancel support enhancements

A previous restriction for canceling an operation running on a statement handle on another thread has been removed.

See "Supported ODBC functions" for further information on TimesTen support of the ODBC SQLCancel function.

New features in Release 11.2.2.0.0

LOB support

TimesTen supports LOBs (large objects). This includes CLOBs (character LOBs), NCLOBs (national character LOBs), and BLOBs (binary LOBs).

For details of support in the C APIs, refer to "Working with LOBs" (general LOB overview and support for ODBC), "LOBs in TimesTen OCI", and "LOBs in TimesTen Pro*C/C++".
Associative array binding

Associative arrays, formerly known as index-by tables or PL/SQL tables, are supported as IN, OUT, or IN OUT bind parameters in TimesTen PL/SQL, such as from an OCI or Pro*C/C++ application. (This is not relevant for TimesTen ODBC applications.) This enables arrays of data to be passed efficiently between an application and the database.

See "Associative array bindings in TimesTen OCI" and "Associative array bindings in TimesTen Pro*C/C++".
ODBC "W" functions

TimesTen now supports some "W" (wide-character) versions of ODBC functions. For example, SQLGetConnectOptionW is supported in addition to SQLGetConnectOption.

See "Supported ODBC functions".
Deprecation of non-persistent XLA

Features for XLA non-persistent mode have been deprecated and removed from the documentation. Use utilities and APIs for persistent XLA only.