不支持的列数据类型ODP.NET [英] Unsupported column datatype ODP.NET

问题描述

我想升级建立在ODP.NET11克来，希望它会提高数据库的调用和数据检索的性能ODP.NET 12C我现有的应用程序。在这方面，我安装了最新的ODP.NET 12c和改变了所有的Oracle项目引用指向最新的 Oracle.ManagedDataAccess.dll 而不是甲骨文.DataAccess.dll 。

I am trying to upgrade my existing application built on ODP.NET 11g to ODP.NET 12c in the hope that it'll improve performance of database calls and data retrieval. In this regard, I installed the latest ODP.NET 12c and changed all Oracle project references to point to the latest Oracle.ManagedDataAccess.dll instead of Oracle.DataAccess.dll.

虽然项目成功生成，我看到一个例外，不支持的列数据类型正在从ExecuteReader方法尝试检索数据时抛出。可悲的是，有不同之处，我进一步搜索相关联的ORA代码。

While the project builds successfully, I'm seeing an exception, "Unsupported column datatype" being thrown from the ExecuteReader method when trying to retrieve data. Sadly, there's no ORA code associated with the exception for me to search further.

有谁知道，如果某些数据类型的支持manageddataaccess.dll？ 。看来，如果我与它的非托管版本（Oracle.ManagedDataAccess.dll）替换它的工作。

Does anyone know if certain datatypes are supported with the manageddataaccess.dll? It seems to work if I replace it with its unmanaged version (Oracle.ManagedDataAccess.dll).

推荐答案

编辑：ODAC的12C第3版（2014年12月发布）的XMLType现在支持ODP.NET，管理驱动程序。如果你打喜欢这里提到的问题，请升级。

As of ODAC 12c Release 3 (released Dec. 2014) XMLType is now supported in ODP.NET, Managed Driver. Please upgrade if you are hitting issues like the one mentioned here.

请注意，也有Oracle.DataAccess.dll（ODP.NET，不受管理的驱动程序的版本12C ）

Please note that there is also a 12c version of Oracle.DataAccess.dll (ODP.NET, Unmanaged Driver)

您使用数据库中的XMLType？这是一个尚未被ODP.NET支持的事情，管理驱动器之一。在写这篇文章的时候，没有管理的驱动程序的支持还是非常有限的支持功能区域包括用户自定义类型，XMLDB功能和数据类型，Oracle高级队列，客户端结果缓存，批量复制，以及Oracle数据库12c的交易Guard特性

Are you using XMLType in the database? That is one of the things that is not yet supported by the ODP.NET, Managed Driver. At the time of this writing, feature areas with no managed driver support or very limited support include user-defined types, XMLDB features and datatypes, Oracle Advanced Queuing, the client result cache, bulk copy, and the Transaction Guard feature of Oracle Database 12c.

的http：//文档.oracle.com / HTML / E41125_02 / intro004.htm

随着时间的推移，更多的数据类型和功能将得到支持，所以总是下载新版本，然后检查新文档该条以及最新消息一节，找出已经添加了什么。

As time goes on, more datatypes and features will be supported, so always download new releases, then check that section of the new documentation as well as the "What's New" section to find out what has been added.

这篇关于不支持的列数据类型ODP.NET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！