The following feature is new in this release:

• VECTOR Data Type

  OraOLEDB supports vectors using CLOB, VARCHAR2, or equivalent data types. OLE DB data retrieval and manipulation use existing OLE DB DBTYPE_STR or DBTYPE_WSTR data types to consume the vector data.

• Increased Database Password Length

  Starting with this release, Oracle Database and client drivers including Oracle Provider for OLE DB support passwords up to 1024 bytes in length.

• SQL BOOLEAN Data Type

  Oracle client drivers now support fetching and binding the new BOOLEAN database column. Applications can use the native database BOOLEAN column data type with a native driver BOOLEAN datatype.

• Oracle Database JSON Data Type

  Oracle Provider for OLE DB supports the native JavaScript Object Notation (JSON) data type in Oracle Database. The JSON data type is optimized for query and DML processing, yielding database performance improvements processing JSON.

  JSON data can be bound as a parameter using the DBTYPE_STR or DBTYPE_WSTR data types.

• JSON Relational Duality

  JSON Relational Duality Views are fully updatable JSON views over relational data introduced in Oracle Database 23ai. Data remains stored in relational tables in a highly efficient normalized format but can be accessed by applications in the form of JSON documents.

  Duality views provide game-changing flexibility and simplicity by overcoming the historical challenges developers have faced when building applications using relational or document models.