Oracle OCI-22053: overflow error Solution

Oracle OCI-22053: overflow error resolution 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, there may be too many digits after the decimal point, which leads to this error. Www.2cto.com solution: Use the round () function, for example, select min (pval), max (pval), round (avg (pval), 5) from hvm_data_dga. round (avg (pval), 5) enables the number to be rounded to five places after the decimal point. Select round (32/14, 3) from dual; output result: 2.286 www.2cto.com select round (32/14, 2) from dual; output result: 2.29