Problem : Decimal's precision value is out of range
Posted: Wed 26 Mar 2008 11:03
I open an oracle database table with the OracleDataTable Class of
then OraDirect-Library. After calling the .Open() Method, I get an Error-Message like "Decimal's precision value is out of range".
The Datatype of the columns in Oracle is defined as Number(), without
any definition of scale or precision.
My code :
OracleDataTable oraQry = new OracleDataTable(" ", MyOracleConn );
oraQry.Close();
oraQry.Clear();
oraQry.SelectCommand.CommandText = "SELECT * FROM MyTable "
+ " WHERE PK_COL = 1231231231 "
+ " ORDER BY SORT_COL";
oraQry.FetchAll = true;
oraQry.Open();
--> After this, I get the following Exception
... Decimal's precision value is out of range
... ... bei CoreLab.Common.DbDataTable.a(Int32 A_0, Boolean A_1)
... ... bei CoreLab.Common.DbDataTable.b(Boolean A_0)
... ... bei CoreLab.Common.DbDataTable.m()
... ... bei CoreLab.Common.DbDataTable.c()
... ... bei CoreLab.Common.DbDataTable.Open()
I am using the corelab version 4.20
oraQry implements the columns after opening the Table as System.Decimal. I think I need a type like System.Double. But I am not able to change the generated Types.
What can I do ?
then OraDirect-Library. After calling the .Open() Method, I get an Error-Message like "Decimal's precision value is out of range".
The Datatype of the columns in Oracle is defined as Number(), without
any definition of scale or precision.
My code :
OracleDataTable oraQry = new OracleDataTable(" ", MyOracleConn );
oraQry.Close();
oraQry.Clear();
oraQry.SelectCommand.CommandText = "SELECT * FROM MyTable "
+ " WHERE PK_COL = 1231231231 "
+ " ORDER BY SORT_COL";
oraQry.FetchAll = true;
oraQry.Open();
--> After this, I get the following Exception
... Decimal's precision value is out of range
... ... bei CoreLab.Common.DbDataTable.a(Int32 A_0, Boolean A_1)
... ... bei CoreLab.Common.DbDataTable.b(Boolean A_0)
... ... bei CoreLab.Common.DbDataTable.m()
... ... bei CoreLab.Common.DbDataTable.c()
... ... bei CoreLab.Common.DbDataTable.Open()
I am using the corelab version 4.20
oraQry implements the columns after opening the Table as System.Decimal. I think I need a type like System.Double. But I am not able to change the generated Types.
What can I do ?