Code in C# + BINARY_DOUBLE data type Problem on Oracle Database

Question

Hi  I ma having Columns as ..... COL7 CHAR(1) COL8 NUMBER(38) COL9 BINARY_DOUBLE COL10 NUMBER(38) . . . . I have used C# to read the values from table but i am unable to read Binary_Double data typetill 8th column i am able to read and from 10 i am able to read if i remove col9 myCommand.CommandText = Select Col1Col2....... from MYTable; OracleDataReader reader = myCommand.ExecuteReader(); i am unable to read from above query. System.NotSupportedException: Unsupported Oracle data type 101 encountered. at System.Data.OracleClient.OracleColumn.Describe(Int32& offset OracleConnection connection OciErrorHandle errorHandle) at System.Data.OracleClient.OracleDataReader.FillColumnInfo() at System.Data.OracleClient.OracleDataReader..ctor(OracleCommand command OciStatementHandle statementHandle StringstatementText CommandBehavior commandBehavior) at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior) Binary_Double makes problem for me how to resolve itwhether i need to convert this data type or how? Thanks!!

Vulpes · Answer

I gather from your code that you're using Microsoft's .NET classes for accessing Oracle which are in the System.Data.OracleClient namespace. It also appears that these classes don't support the BINARY_DOUBLE type. These classes have been deprecated and are going to be removed in a future version of the .NET Framework. For confirmation see: http://msdn.microsoft.com/en-us/library/77d8yct7.aspx You'll notice that MS are recommending that you use a third party provider instead and ODP.NET which is Oracle's own provider seems to be your best bet. According to this link I found the BINARY_DOUBLE type is supported in version 10.1 or later: http://docs.oracle.com/html/B28089_01/whatsnew.htm Here's a link to the download page for various versions of ODP.NET including the latest version 11.2: http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html