- 18 Jan, 2020
- 0 Comments
- 24 Secs Read
ora-01722 invalid number in oracle
In this blog, We will try to understand how to resolve the ORA-01722 error.
Problem Statement
ora-01722 invalid number in oracle
Solution
- First describe the table and check for data types by using desc command
- Check the type of data you are inserting and type of column
- An ORA-01722 error occurs when an attempt is made to convert a character string into a number, and the string cannot be converted into a number
- Check the WHERE Clause for Implicit Conversion
#ora-01722