Oracle Development Technology: Overflow Error Resolution

Oracle numeric data types can store up to 38 bytes of precision. When the Oracle numeric conversion

When you are a common language runtime data type, the number of digits behind the decimal point may be excessive, which can cause this error.

Workaround:

Use the Round () function:

For example: select min (pval), Max (PVal), round (avg (pval), 5) from HVM_DATA_DGA.

Round (AVG (pval), 5) keeps the numeric decimal point followed by rounding 5 digits.

Select Round (32/14, 3) from dual;

Output Result: 2.286

Select Round (32/14, 2) from dual;

Output Result: 2.29