Skip to Content
0
Jul 20, 2020 at 12:21 PM

CURR (10,2) what values can go into this data type?

477 Views

Hi All,

If I have a variable of CURR(10,2) what is the correct values that can go into this variable?

A.) 12 characters in total. 10 whole numbers with 2 decimal places.

B.) 10 characters in total. 8 whole numbers with 2 decimal places.

I have encountered this dump in our system:

Short Text
SQL error "SQL code: 1438" occurred while accessing table "/ACNLQD/NUMRANGE".

What happened?
Database error text: "SQL message: ORA-01438: value larger than specified
precision allowed for this column"

Per checking for values that didn't dump, there was a field in the table that had a value 8 whole numbers and 2 decimal places. But for the dump encountered, the variable/field had 9 whole numbers and 2 decimal places(a total of 11). Is this what's causing the dump in our system? Thank you.