Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA 1801 - Dateformat too long for internal buffer
Nicolas, from past experience I know that OCI programs can insert
invalid values in date columns. It could well be that the underlying
code in Delphi/BDE or perhaps even the jdbc drivers you are using use
OCI.
You might consider adding a trigger to the table that validates the
date information as a debugging tool to learn where the invalid
information is coming from. That is you can add it, capture an error,
and then drop the trigger to allow normal processing while you do more
research with additional information in hand.
HTH -- Mark D Powell -- Received on Thu Mar 30 2006 - 09:20:44 CST