Troubleshooting > Troubleshooting DataConnect > Value larger than specified precision
Was this helpful?
Value larger than specified precision
 
Error Code
8
Error Message
executeStatement(StmtExecute): error 1438 (ORA-01438: value larger than specified precision allowed for this column)
Description
This error message is displayed for all connector data types which have Precision and Decimal property, when the number you are trying to store is too big for the field.
Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a precision of 5 and a scale of 2.
Cause/Solution
Cause: The number you are trying to store is too big for the field.
Solution: Correct the Precision or Decimal value:
1. Click the Mapping tab.
2. Check the Target Field Properties.
3. Correct the Precision or Decimal value.
4. Save and Run the Map.
Related Information
Last modified date: 10/22/2024