Yuvipoy

Yuvipoy

  • NA
  • 7
  • 16.9k

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

Aug 28 2012 7:13 AM
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!!


Answers (1)