ORA-01722: invalid number

Causes for ORA-01722: invalid number?

ORA-01722 ("invalid number") error occurs when we try to convert a character string to a number & that cannot be converted into a valid number. As we know Valid numbers contain the digits '0' through '9'.There are many situations where this will occur with you.Like, Numeric column may be the object of an INSERT or an UPDATE statement. Or may be you have used numeric in part of where clause.Or if there is no numeric columns appear in the mentioned statement.

Examples : - 

How to fix it

You need to check expression which caused the problem for you.For the solution, Always keep in mind that this may be caused by the simple typo with query or in the program logic. In many cases, we found that this occurs due to bad data.

I will update this post again. I have copied this from other blog and after doing the practical, I will update with the solution. I am working on this blog.


Keep sharing :)