In this post, you’ll learn more about the Oracle ErrorORA-08463: overflow converting decimal number to Oracle number with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-08463: overflow converting decimal number to Oracle number
Reason for the Error ORA-08463: overflow converting decimal number to Oracle number
The output variable passed to a UTL_PG RAW_TO_NUMBER was not large enough to hold the Oracle number resulting from the input decimal number.
How to fix the Error ORA-08463: overflow converting decimal number to Oracle number ?
You can fix this error in Oracle by following the below steps
Be sure that the input decimal number is valid, and besure that the output variable is large enough to hold the Oracle number value.