Learn the cause and how to resolve the ORA-01722 error message in Oracle.
When you encounter an 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 unsuccessful.
The option(s) to resolve this Oracle error are:
Only numeric fields or character fields that contain numeric values can be used in arithmetic operations. Make sure that all expressions evaluate to numbers.
If you are adding or subtracting from dates, make sure that you added/substracted a numeric value from the date.