ora-01722 invalid number in oracle

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 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