SOLVED

ora-01722 invalid number in oracle

Asked by OracleDba••20 views•oracle
1
2
3
4
5
6
7
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
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
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
OracleDba•

Post Your Solution