Exception when querying data with INTERVAL TO SECOND column type

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 1
Joined: Tue 01 Oct 2013 19:37

Exception when querying data with INTERVAL TO SECOND column type

Post by Namit » Tue 01 Oct 2013 19:59

I am getting Arithmetic Overflow exception when querying data from a table with one of the column as INTERVAL TO SECOND datatype. Though there were no issues in inserting same dataset. Also one thing I have noticed is the data values are sometime 0 for this column but it is a normal behavior. In entity model this column is mapped to "Time" and in c# it is mapped to "TimeSpan". The version of Devart.data.Oracle is

datatype for this column in oracle = INTERVAL DAY(9) TO SECOND(7) and is Nullable

A Sample data would like this:

D0C0DB2B3C0DB243B59DC605A75824C9 833C3FE482A3DC4BA8C423273DAD1472 10/1/2013 4:00:00 PM (null) 5 Robot ULR1 Automatic (null) +000000000 00:42:15.0000000 (null) (null) (null) (null)

Thanks in advance

Code: Select all

Recovery 1 failed:System.OverflowException: Arithmetic operation resulted in an overflow.
   at Devart.Data.Oracle.[u]OracleIntervalDS[/u]..ctor(IntPtr A_0, bf A_1)
   at Devart.Data.Oracle.v.o(Byte[] A_0, Int32 A_1, Int32 A_2)
   at Devart.Data.Oracle.au.q(Byte[] A_0, Int32 A_1, Int32 A_2)
   at Devart.Data.Oracle.OracleDataReader.GetValue(Int32 i)
   at Devart.Data.Oracle.Entity.ad.a(Int32 A_0)
   at System.Data.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal)
   at System.Data.Common.Internal.Materialization.Shaper.GetPropertyValueWithErrorHandling[TProperty](Int32 ordinal, String propertyName, String typeName)
   at lambda_method(Closure , Shaper )
   at System.Data.Common.Internal.Materialization.Shaper.HandleEntityAppendOnly[TEntity](Func`2 constructEntityDelegate, EntityKey entityKey, EntitySet entitySet)
   at lambda_method(Closure , Shaper )
   at System.Data.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)
   at System.Data.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)

Site Admin
Posts: 8549
Joined: Thu 14 Aug 2008 12:44

Re: Exception when querying data with INTERVAL TO SECOND column type

Post by Shalex » Thu 03 Oct 2013 09:57

We cannot reproduce the problem with the latest (7.9.333) build of dotConnect for Oracle. Please upgrade to 7.9.333. If this doesn't help, send us a small test project.

If you do not have access to the licensed 7.9.333, you can check the functionality with the trial version.

Post Reply