Learn the reason and how to resolve the ORA-01722 error message in Oracle.
When you stumble upon an ORA-01722 error, the following error message will appear:
ORA-01722: invalid number
You executed a SQL statement that tried to convert a string to a number, but it was once unsuccessful.
The option(s) to resolve this Oracle error are:
Only numeric fields or persona fields that include numeric values can be used in arithmetic operations. Make certain that all expressions evaluate to numbers.
If you are including or subtracting from dates, make positive that you added/substracted a numeric fee from the date.