ORA-01821 date format not recognized

ORA-01821 date format not recognized

Postby sclegg » Tue 15 Sep 2009 11:07

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....
sclegg
 
Posts: 6
Joined: Fri 11 Sep 2009 15:51
Location: Idaho

Postby AndreyR » Fri 18 Sep 2009 07:16

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
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

value of the timestamp with time zone

Postby sclegg » Fri 18 Sep 2009 12:35

15-DEC-04 10.37.00.000000 PM AMERICA/BOISE
sclegg
 
Posts: 6
Joined: Fri 11 Sep 2009 15:51
Location: Idaho

Postby AndreyR » Mon 21 Sep 2009 13:15

Thank you for the report, we will investigate the problem.
I will let you know about the results of our investigation.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Tue 06 Oct 2009 13:20

We have fixed the problem. The fix will be included in the next build of dotConnect for Oracle.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle