Re: Unusual ORA-01438 Errors

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 May 2006 05:38:33 -0700
Message-ID: <1148042313.162123.55400@j33g2000cwa.googlegroups.com>

My experience with "numeric or value error" and "value larger than specified precision allows for this column" is that Oracle is telling the truth.

If you can select the same rows that fail in the program take a very close look at each of the returned values and compare their value to the value of the receiving field in C.

Also check that none of the tables referenced in the query had any columns altered larger recently. Being that Oracle stores numbers as variable length the altering of a column value to handle one additional digit without the program being changed to match would not necessarily result in an error until a data value that needed the extra digit was encountered.

HTH -- Mark D Powell -- Received on Fri May 19 2006 - 07:38:33 CDT