ORA-01821 date format not recognized

[sclegg]

ORA-01821 date format not recognized

Ran into this error in run time when accessing Oracle database columns containing timestamp with time zone in the ASP.Net web page (View page of ASP.NET MVC). What am I missing? I'm using docConnect for Oracle (Direct) version 5.25.42.0. The stack trace is:


at Devart.Data.Oracle.OracleTimeStamp.a(String A_0, SByte& A_1, SByte& A_2)\r\n at Devart.Data.Oracle.OracleTimeStamp..ctor(Int32 year, Int32 month, Int32 day, Int32 hour, Int32 minute, Int32 second, Int32 nanosecond, String timeZone, OracleDbType dbType)\r\n at Devart.Data.Oracle.ae.m(Byte[] A_0, Int32 A_1, Int32 A_2)\r\n at Devart.Data.Oracle.af.g(Byte[] A_0, Int32 A_1, Int32 A_2)\r\n at Devart.Data.Oracle.OracleDataReader.GetDateTime(Int32 i)\r\n at Devart.Data.Oracle.Entity.d.a.b.a(Int32 A_0)\r\n at Devart.Common.Entity.c.a.a.GetValue(Int32 ordinal)\r\n at System.Data.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal)\r\n at System.Data.Common.Internal.Materialization.Shaper.GetColumnValueWithErrorHandling[TColumn](Int32 ordinal)\r\n at lambda_method(ExecutionScope , Shaper )\r\n at System.Data.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)\r\n at System.Data.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()\r\n at ASP....

[AndreyR]

Please post here the value of the column that causes the problem, selected using this query:

Code: Select all

select TO_CHAR(column, 'DD-MON-RR HH.MI.SSXFF AM TZR') from table

[sclegg]

15-DEC-04 10.37.00.000000 PM AMERICA/BOISE

[AndreyR]

Thank you for the report, we will investigate the problem.
I will let you know about the results of our investigation.

[AndreyR]

We have fixed the problem. The fix will be included in the next build of dotConnect for Oracle.