Re: Unusual ORA-01438 Errors

Thanks for the response. This is probably where I fail at Pro C and what it can do, but how would I
be able to look at the returned values and compare their value to the value of the receiving field in C? I suggested doing a select, to pull the data before executing the "update" as well as printing out the host variables. The unfortunate part of that is they are afraid it will slow down processing and they cannot have that.

I was hoping that someone would have a suggestion for printing out the values without involving doing a "select" first. Of course, if that is not possible, then that would enforce my earlier thoughts that a "select" would need to be done in order to get a "before" and "after" snapshot of what was there.

Thanks!

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:1148042313.162123.55400_at_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 - 08:12:41 CDT