How to resolve ora 01722 invalid number?

By replacing the spaces with zeroes, the error can be resolved. There are ways to fix this problem, with the first looking at an “INSERT INTO… VALUES (…)” attempt. Go through the steps above; check the data you are entering to make sure the numerical values are in line, and correct any that are invalid. Lees verder »