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 -> Re: ORA 1801 - Dateformat too long for internal buffer

Re: ORA 1801 - Dateformat too long for internal buffer

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 30 Mar 2006 07:20:44 -0800
Message-ID: <1143732044.719203.220930@u72g2000cwu.googlegroups.com>


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

Original text of this message

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