OCI-22053: causes and solutions for overflow errors

 

Yesterday, in the Oracle database-based SQL Performance analysis, it was found that the data to fill to the memory, a OCI-22053: overflow error occurs.

After analyzing the SQL statement, it is executed normally in Oracle, indicating that the SQL statement itself is normal, so we guess the problem lies in the data.

 

Hash_value
Elapsed_time_per_exe

238087931 0.012498685

615028291 0.0001470192

424344360 0.0001036334

Try to reduce the precision, use the round () function to retain 2 decimal places, and then find it is OK. 

It can be seen that the conversion overflow error is caused by the precision problem.

Google Internet has the following explanation:

The Oracle numeric data type can store up to 38 bytes of precision, exceeding the CLR data type.

If this conversion existsOracle OCI-22053 overflow error.