67582

Unsupported column datatype ODP.NET

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.

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.

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).

Answer1:

Edit: 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.

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

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://docs.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.

Recommend

  • Getting Transact SQL query result in C# Application
  • My database system cannot find the file specified in asp.net
  • Invalid attempt to read when no data is present in ASP.NET
  • Avoiding ORA-00955: name is already used by an existing object
  • Hibernate Criteria causes ORA-00918: column ambiguously defined
  • Xcode 4 - Is there something in Interface Builder like “reveal in canvas”?
  • Limit the amount of results from mySQL conditionally?
  • What is the difference between running in VS 2010 and running a builded EXE?
  • What is using connection in the code
  • Converting a data frame into named object in R
  • Using firebase with WatchKit
  • Is it ok to submit a build to the app store for testing when a previous build is waiting for review?
  • Referring to individual variables in … with dplyr quos
  • ObjectMaterialize in EF not firing on first level query
  • Convert data type in R or Python
  • Exclusive access established by another Thread Java smartcardio
  • Controlling Prolog variable value selection
  • Visual Studio not stopping on an exception being thrown
  • ORA-12154: TNS:could not resolve the connect identifier specified
  • Multiple versions of iTunesArtwork in one project?
  • How do I add a File Type Association in a Windows Phone 8.1 app manifest?
  • Issue with routerLink directive
  • Function calls are not supported. Consider replacing the function or lambda with a reference to an e
  • Invalid object name 'dbo.Item'
  • Jenkins: FATAL: Could not initialize class hudson.util.ProcessTree$UnixReflection
  • TextToSpeech.setEngineByPackageName() triggers NullPointerException
  • Unable to get column index with table.getColumn method using custom table Model
  • OpenGL 3.3 on Mac OSX El Capitan with LWJGL
  • Can I display google adwords (AdView) in javafx on android
  • Apache 2.4 and php-fpm does not trigger apache http basic auth for php pages
  • javascript inside java/jsp code
  • Can I make an Android app that runs a web view in Chrome 39?
  • Trying to switch camera back to front but getting exception
  • How do I rollback to a specific git commit
  • Android Studio and gradle
  • Free memory of cv::Mat loaded using FileStorage API
  • Angular 2 constructor injection vs direct access
  • IndexOutOfRangeException on multidimensional array despite using GetLength check
  • Programmatically clearing map cache
  • How can i traverse a binary tree from right to left in java?