Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA 1801 - Dateformat too long for internal buffer

ORA 1801 - Dateformat too long for internal buffer

From: Nicolas Bronke <Nicolas_Bronke_at_web.de>
Date: Thu, 30 Mar 2006 16:21:17 +0200
Message-ID: <4927quFminkaU1@individual.net>


On one database table I got this strange error (Oracle 9.2.0.4 Linux)

ORA-01801: Datumsformat zu lang f³r internen Puffer

I found out that in a date column and in some rows the datevalue is "corrupted"
If I make an update on this specific row and column everything works okay.

But I am wondering how such incorrect value could be entered in this table. As I know, this table is updated by a delphi/BDE program and a JAVA program. But I cannot imagine, that from there the problem is coming.

Thank you for any hints

Regards
Nicolas Received on Thu Mar 30 2006 - 08:21:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US