- Varchar is bust - "Inserted value too large for column"
- Numeric field is bust - "value larger than specified precision allows for this"
You quite often see "Inserted value too large for column" when developing Java against an Oracle Db which means that you've bust a VARCHAR2 usually. If you bust a numeric field that error is different "value larger than specified precision allows for this". This can happen on numeric key fields that are too small for a corresponding sequence generator number say when the generator reaches 9 digits and the key field was only spec'd to be a Number(8).
Wednesday, 5 March 2008
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment