Specified argument was out of the range of valid values. Parameter name: Year, Month, and Day parameters describe an unr

[Saijash]

I am getting following error while filling the datatable from oracle database.

Any clues what is the cause.

Thanks
Saijash


Specified argument was out of the range of valid values. Parameter name: Year, Month, and Day parameters describe an unrepresentable DateTime.
at System.DateTime.DateToTicks(Int32 year, Int32 month, Int32 day)
at System.Data.OracleClient.OracleDateTime.ToDateTime(Byte[] rawValue)
at System.Data.OracleClient.OracleDateTime.MarshalToDateTime(NativeBuffer buffer, Int32 valueOffset, Int32 lengthOffset, MetaType metaType, OracleConnection connection)
at System.Data.OracleClient.OracleColumn.GetDateTime(NativeBuffer buffer)
at System.Data.OracleClient.OracleColumn.GetValue(NativeBuffer buffer)
at System.Data.OracleClient.OracleDataReader.GetValues(Object[] values)
at System.Data.Common.SchemaMapping.LoadDataRow(Boolean clearDataValues, Boolean acceptChanges)
at System.Data.Common.DbDataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDataReader dataReader)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

[Paul]

You are using Oracle Data Provider. We cannot give you support on this product.
Possibly the value in database is out of range or corrupted (this can happen with TIMESTAMP fields).
The DateTime value type represents dates and times with values ranging from 12:00:00 midnight, January 1, 0001 Anno Domini (Common Era) to 11:59:59 P.M., December 31, 9999 A.D. (C.E.)
Try to do this with OraDirect .NET (CoreLab.Oracle.OracleCommand, CoreLab.Oracle.OracleDataAdapter)