Oracle Solution for Error ora-08463

ORA-08463: overflow converting decimal number to Oracle number

What triggered the Error:

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.

What should we do to fix it:

Be sure that the input decimal number is valid, and besure that the output variable is large enough to hold the Oracle number value.