Oracle numeric data types can store up to 38 bytes of precision.
When the Oracle numeric value is converted to the Data Type of the Common Language Runtime database,
The Oracle value may become too large. This causes an oracle OCI-22053 overflow error.
The solution is to use the round function.
How to use ORACLE roundFunction (Four to five)
Description:Returns a numeric value, which is the result of a four-digit five-digit calculation based on the specified small data element.
Select round (number, [decimal_places]) from dual
Metric data:
Number:Data to be processed
Decimal_places:Four to five,Bitwise of Small Data(Reset0)
Sample:
Select round (123.456) from dual;Restore123
Select round (123.456, 0) from dual;Restore123
Select round (123.456, 1) from dual;Restore123.5
Select round (123.456, 2) from dual;Restore123.46
Select round (123.456, 3) from dual;Restore123.456
Select round (-123.456, 2) from dual;Restore-123.46