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.
This release of the document provides information about TimesTen support for the ODBC SQLGetInfo and SQLColAttributes functions.
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.
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.
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.