datatype for this column in oracle = INTERVAL DAY(9) TO SECOND(7) and is Nullable
A Sample data would like this:
ID KPI_DEFINITION_ID TIMESTAMP FLOAT_VALUE UNIT_ID IDENTIFIER_1 IDENTIFIER_2 IDENTIFIER_3 DATE_TIME_VALUE INTERVAL_VALUE INTEGER_VALUE STRING_VALUE IS_STRING_NULL BOOL_VALUE
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)