ORA -01438 - value larger than specified precision allowed for this column
abladbSep 13 2010 — edited Sep 15 2010Hi there,
It should be easy to understand this problem. However if I have to ask you is because I can't achieve it.
The problem comes up "When inserting or updating records, a numeric value was entered that exceeded the precision defined for the column." However, I can't find such column.
Is there a way through which I can found out the column name causing an ORA-01438? Please, check I am using Forms 10g. I've tried tracing the session with messages to show when the error comes up, and it does when doing a POST clause, so I can't commit. Actually, it shows up at any field; I have tried changing a field with datatype number (2), changing a '1' for a '2' and it comes up, and... changing a field varchar2(15) 'whatever I have' for 'update' and the error comes up. The other data fields show as they come after querying, so I don't change them. And at Block's propeties I have the 'Update Changed Columns Only' set to 'Yes'.
So please, i need some help.
Thanks in advance!!!
Edited by: abladb on Sep 13, 2010 9:16 AM