We are using DotConnect for Oracle 8.4.254 to access Oracle database.
We have a table which has 284 columns,we are using simple SQL to get data from the table:
Some code :
Code: Select all
OracleConnection con = new OracleConnection();
con.ConnectionString = "user id=myuserid;password=mypassword;server=myserver;Unicode=true;connection timeout=30";
OracleCommand cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText = "select * from bigtable";
con.Open();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine ( reader.GetValue(0));
}
}
Console.WriteLine("testbigsource finish");
con.Close();System.OverflowException:Arithmetic operation resulted in an overflow.
at Devart.Data.Oracle.OracleDataReader.a()
at Devart.Data.Oracle.OracleDataReader.Read()
at DevartTest.Program.TestBigSource()
at DevartTest.Program.Main(String[] args)
Sometimes the error message is a little bit different:
System.OverflowException:Array dimensions exceeded supported range.
If I set command.FetchSize=100, the error does not happen
Or if I use DotConnect for Oracle 7.7.276, the error does not happen either.
Could you tell me why the error happen and how to solve it?