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


  • 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


Thanks for visiting this post. Please contact us if you are looking for training.
Subscribe to our channel for unlimited learning. Thank you!!!

Share and Enjoy !

0 0

Leave a Comment

Your email address will not be published. Required fields are marked *