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 type,till 8th column i am able to read and from 10 i
am able to read if i remove col9
myCommand.CommandText = "Select Col1,Col2,....... 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 it,whether 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