1. ODBC Developer's Guide
  2. Changes in ODBC Developer's Guide

Changes in ODBC Developer's Guide

The following are the changes in ODBC Developer's Guide for Oracle Database 23ai, and earlier releases:

New Features in 23ai

The following are the new features in ODBC Developer's Guide for Oracle Database 23ai.

Parent topic: Changes in ODBC Developer's Guide

ODBC Release 23ai

The following new features are added to the Oracle Database ODBC driver, release 23ai.

ODBC Support for SQL BOOLEAN Data Type

The Oracle Database ODBC driver supports a native SQL BOOLEAN data type, using SQL_BIT to map to the SQL BOOLEAN data type, and returning "1" or "0."

ODBC Support for VECTOR Data Type

The Oracle Database ODBC driver supports VECTOR data type, using SQL_CHAR to map to the VECTOR data type.

See Implementation of Data Types (Advanced)

Parent topic: New Features in 23ai

New Features in Earlier Releases

The following are the new features in the earlier releases of the Oracle Database ODBC driver.

Parent topic: Changes in ODBC Developer's Guide

ODBC Release 21c, Version 21.1

There are no new features for Oracle Database ODBC Driver Release 21c, Version 21.1.

Parent topic: New Features in Earlier Releases

ODBC Release 19c, Version 19.1.0.0.0

There are no new features of Oracle Database ODBC Driver, Release 19c, Version 19.1.0.0.0 software for the Microsoft Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows 7, Windows 8, Windows 8.1, Windows 10, Linux X86-64 (32-bit, 64-bit), Sun Solaris SPARC64 (32-bit, 64-bit), IBM AIX 5L (32-bit, 64-bit), Sun Solaris X64 (32-bit, 64-bit), HPUX IA64 (32-bit, 64-bit), ZLinux (32-bit, 64-bit) operating systems.

Parent topic: New Features in Earlier Releases

ODBC Release 18c, Version 18.1.0.0.0

Features of Oracle Database ODBC Driver Release 18c, Version 18.1.0.0.0 software for the Microsoft Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows 7, Windows 8, Windows 8.1, Windows 10, Linux X86-64 (32-bit, 64-bit), Sun Solaris SPARC64 (32-bit, 64-bit), IBM AIX 5L (32-bit, 64-bit), Sun Solaris X64 (32-bit, 64-bit), HPUX IA64 (32-bit, 64-bit), ZLinux (32-bit, 64-bit) operating systems are described as follows:
  • unixODBC ODBC Driver Manager is upgraded from unixODBC–2.3.2 to unixODBC–2.3.4.

Parent topic: New Features in Earlier Releases

ODBC 12.2.0.1.0

Features of Oracle Database ODBC Driver Release 12.2.0.1.0 software for the Microsoft Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows 7, Windows 8, Windows 8.1, Windows 10, Linux X86-64 (32-bit, 64-bit), Sun Solaris SPARC64 (32-bit, 64-bit), IBM AIX 5L (32-bit, 64-bit), Sun Solaris X64 (32-bit, 64-bit), HPUX IA64 (32-bit, 64-bit), ZLinux (32-bit, 64-bit) operating systems are described as follows:

  • Support is added for long identifiers up to 128 bytes.

  • Support is added for time stamp with time zone and time stamp with local time zone.

    This feature does not require changes to the existing ODBC application where ODBC TIMESTAMP data type is used. If an existing application uses ODBC TIMESTAMP data type and the database column is TIMESTAMP, the current behavior is preserved.

    For database column TIMESTAMP WITH TIMEZONE or TIMESTAMP WITH LOCAL TIMEZONE, the time component in the ODBC TIMESTAMP_STRUCT is in the user’s session time zone. This behavior is transparent to the user’s application, requiring no change to the ODBC application.

Parent topic: New Features in Earlier Releases

Deprecated Features

The following is the deprecated feature in ODBC Developer's Guide for Oracle Database Release 23ai.

Oracle OLAP

Analytic workspaces, the OLAP DML programming language, financial reporting, and the OLAP Java API continue to be deprecated in Oracle Database 23ai.

Be aware that OLAP will not be supported beyond the term of the current release (Oracle Database 23ai) premier support. Oracle strongly recommends that you do not start new projects using OLAP and begin migrating applications using OLAP to alternatives now. If your application requires an in-database dimensional model, then consider using Oracle Analytic Views. Analytic views provide a dimensional semantic model, calculations, and query semantics using data in Oracle Database. When used with columnar tables, analytic views provide query performance similar to the OLAP Option. If your application requires support for advanced dimensional analytics, what-if analysis, or forecasting, then consider Oracle Essbase. Oracle Essbase is a multidimensional database management system with support for complex dimensional business analytics.

Parent topic: Changes in ODBC Developer's Guide