Question

2
Replies
3059
Views
DanangPanjiP Member since 2016 4 posts
SMMF
Posted: 3 years ago
Last activity: 3 years 4 months ago
Closed

Maximum length of Decimal

I have problem that I can't insert or save a record with 10 digit or 1 billion in Decimal Data Type. How to resolve this? Is there any Numeric Data Type that have more than 10 Digit? I'm using DECIMAL in my Data Type.

Here is my ERROR log

DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: numeric field overflow
Detail: A field with precision 18, scale 9 must round to an absolute value less than 10^9.
| SQL Code: 0 | SQL State: 22003

Thanks in Advance.

Data Integration
Moderation Team has archived post
Share this page LinkedIn