Oracle.ManagedDataAccess 23.8.0

Oracle Logo

Oracle.ManagedDataAccess 23.8.0

Release Notes for Oracle Data Provider for .NET, Managed Driver NuGet Package

March 2025

Managed Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database for .NET Framework and is 100% managed code. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including AI vectors, Real Application Clusters, Application Continuity, JSON Relational Duality, and Fast Connection Failover.

This document provides information that supplements the Oracle Data Provider for .NET (ODP.NET) documentation.

New Features

  • AI: Oracle Sparse Vector and Dense Vector Data Types
  • OracleDataSource (Oracle DbDataSource)
  • SQL Injection Protection with OracleDBMSAssert
  • Bulk Copy Boolean Data Type Support
  • Password-Protected Wallet (PKCS#12) Support
  • Password-Protected Wallet (PKCS#12) and Auto-Login Wallet (SSO) Support in Secure External Password Store (SEPS)
  • Automatic Connection Recovery

Bug Fixes since Oracle.ManagedDataAccess 23.7.0

  • Bug 37753231 - FLEX DENSE VECTOR COLUMNS HAVE INCONSISTENT BEHAVIOR IN ORACLEDATAREADER.GETFIELDTYPE(), ORACLEDATAREADER.GETVALUE(), AND ORACLEDATAADAPTER.FILL()
  • Bug 37705687 - WHEN ORACLEAQQUEUE.LISTEN() TIMES OUT, IT SHOULD RETURN NULL, RATHER THAN AN EXCEPTION THROWN FOR ORA-25254.
  • Bug 37571978 - OPTIMIZE ORACLEDECIMAL.TOSTRING() AND ORACLEDATAREADER.GETSTRING() FOR NUMBER COLUMNS : HIGHER THROUGHPUT AND LOWER MEMORY USAGE
  • Bug 37563784 - OPTIMIZE TOSTRING() METHOD FOR ORACLEDATE : HIGHER THROUGHPUT AND LOWER MEMORY USAGE
  • Bug 37525372 - SYSTEM.ARGUMENTOUTOFRANGEEXCEPTION : INDEX WAS OUT OF RANGE, IS OBSERVED WHEN CLOB COLUMNS ARE IN THE RESULT SET AND FETCHSIZE IS SET
  • Bug 37517481 - PERFORMANCE ISSUE WHEN ONLY NULLS ARE IN THE RESULT SET
  • Bug 37495128 - ORA-50232: NETWORK TRANSPORT: TCP TRANSPORT ADDRESS CONNECT FAILURE DUE TO CACHED, STALE IP ADDRESS
  • Bug 37490193 - ADD ORACLEBULKCOPYOPTIONS.ENFORCEINDEXCHECKS ENUMERATION VALUE TO ENABLE/DISABLE INDEX CHECKS DURING BULKCOPY
  • Bug 37365816 - SUPPRESSGETDECIMALINVALIDCASTEXCEPTION WITH UDT NUMERIC PROPERTIES GENERATE ARITHMETIC OPERATION RESULTED IN AN OVERFLOW ERROR
  • Bug 37160309 - TTC ERROR IS ENCOUNTERED WHEN OPENTELEMETRY ENABLESQLIDTRACING IS ENABLED AND COMMAND EXECUTION RETURNS REF CURSOR
  • Bug 36759038 - APOSTROPHES IN CONNECT DESCRIPTOR USER VARIABLE CAUSE ORA-00303: SYNTAX ERROR IN NAME-VALUE STRING

Installation Changes

The following app/web.config entries are added when installing the managed ODP.NET NuGet package to your application:

  1. Configuration Section Handler

A configuration section handler entry is added to the app/web.config to enable applications to add an <oracle.manageddataaccess.client> section for ODP.NET, Managed Driver-specific configuration.

Note: For a web app, if the same config section handler for "oracle.manageddataaccess.client" also exists in machine.config but the "Version" attribute values are different, an error message "There is a duplicate 'oracle.manageddataaccess.client' section defined." may be observed at runtime. To resolve the error, remove the "oracle.manageddataaccess.client" config section handler entry in the machine.config. If other applications on the machine depend on this machine.config entry, move the config section handler entry to each application's web.config file.

  1. DbProviderFactories

The DbProviderFactories entry is added for applications that use DbProviderFactories and DbProviderFactory classes. Any DbProviderFactories entry for "Oracle.ManagedDataAccess.Client" in the machine.config will be ignored.

  1. Dependent Assembly

The dependent assembly entry is created to ignore policy DLLs for Oracle.ManagedDataAccess.dll. It directs the app to always use the Oracle.ManagedDataAccess.dll version that is specified by the "newVersion" attribute in the "bindingRedirect" element. The "newVersion" attribute corresponds to the Oracle.ManagedDataAccess.dll version which came with the NuGet package.

  1. Data Sources

The data sources entry is added to provide a template on how a data source can be configured in the app/web.config. Simply rename the sample data source to an alias of your choosing; modify the PROTOCOL, HOST, PORT, SERVICE_NAME as required; and un-comment the "dataSource" element. Once that is done, the alias can be used as the "data source" attribute in your ODP.NET connection string.

Copyright (c) 2024, 2025, Oracle and/or its affiliates.

Showing the top 20 packages that depend on Oracle.ManagedDataAccess.

Packages Downloads
DapperExtensions
A small library that complements Dapper by adding basic CRUD operations (Get, Insert, Update, Delete) for your POCOs. For more advanced querying scenarios, Dapper Extensions provides a predicate system.
 27
FreeSql.Provider.Oracle
FreeSql 数据库实现，基于 Oracle 11
 17
FreeSql.Provider.Oracle
FreeSql 数据库实现，基于 Oracle 11
 18
FreeSql.Provider.Oracle
FreeSql 数据库实现，基于 Oracle 11
 20
FreeSql.Provider.Oracle
FreeSql 数据库实现，基于 Oracle 11
 21
Oracle.ManagedDataAccess.EntityFramework
This NuGet package is for ODP.NET, Managed Driver applications that use Code First and/or Entity Framework 6 applications. It will add and configure the Oracle Entity Framework assembly for your application.
 21
Oracle.ManagedDataAccess.EntityFramework
This NuGet package is for ODP.NET, Managed Driver applications that use Code First and/or Entity Framework 6 applications. It will add the Oracle Entity Framework assembly and auto-configure for its use. Note that this package does not include ODP.NET, Managed Driver which is available as a separate NuGet package.
 18

.NET Framework 4.7.2

Version Downloads Last updated
23.8.0 1 04/14/2025
23.7.0 7 01/16/2025
23.6.1 11 11/27/2024
23.6.0 9 11/30/2024
23.5.1 9 11/30/2024
23.5.0 10 12/10/2024
23.4.0 16 05/27/2024
23.3.3-dev 12 12/02/2024
23.3.2-dev 9 12/02/2024
23.3.1-dev 9 12/02/2024
23.3.0-dev 11 12/02/2024
23.2.0-dev 10 12/09/2024
21.18.0 1 04/14/2025
21.17.0 6 12/25/2024
21.16.0 9 12/20/2024
21.15.0 11 12/04/2024
21.14.0 9 12/03/2024
21.13.0 15 05/27/2024
21.12.0 8 12/10/2024
21.11.0 14 05/27/2024
21.10.0 11 05/27/2024
21.9.0 14 05/27/2024
21.8.0 14 05/27/2024
21.7.0 16 05/27/2024
21.6.1 17 06/07/2022
21.5.0 15 05/27/2024
21.4.0 11 05/27/2024
19.27.0 1 04/14/2025
19.26.0 6 12/25/2024
19.25.0 9 12/02/2024
19.24.0 11 12/02/2024
19.23.0 11 05/27/2024
19.22.0 11 05/27/2024
19.21.0 14 05/27/2024
19.20.0 14 05/27/2024
19.19.0 16 05/27/2024
19.18.0 15 05/27/2024
19.17.0 16 05/27/2024
19.16.0 14 05/27/2024
19.15.1 12 05/27/2024
19.14.0 19 04/26/2022
19.13.0 9 12/03/2024
19.11.0 14 05/05/2023
19.10.1 12 05/27/2024
19.10.0 14 05/27/2024
19.9.0 13 05/27/2024
19.8.0 14 05/27/2024
19.7.0 15 05/16/2023
19.6.0 14 05/27/2024
19.5.0 8 12/01/2024
19.3.1 13 05/27/2024
19.3.0 9 12/02/2024
18.15.1 15 05/27/2024
18.15.0 16 05/27/2024
18.6.0 13 05/27/2024
18.3.0 15 05/27/2024
12.2.20230118 13 05/27/2024
12.2.20220118 14 05/27/2024
12.2.1100 10 05/27/2024
12.1.24230118 13 05/27/2024
12.1.24220118 12 05/27/2024
12.1.24160719 12 05/27/2024
12.1.24160419 12 05/27/2024
12.1.2400 12 05/27/2024
12.1.22 14 05/27/2024
12.1.21 13 05/27/2024