Question

2
Replies
3351
Views
Close popover
Danang Panji Prasetyo (DanangPanjiP)
SMMF

SMMF
ID
DanangPanjiP Member since 2016 4 posts
SMMF
Posted: May 2, 2017
Last activity: May 2, 2017
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.