This discussion is archived
4 Replies Latest reply: Jul 11, 2013 4:15 PM by learner1 RSS

ORA-01722: Invalid Number error coming on upgrade from to

955210 Newbie
Currently Being Moderated



Recently i upgraded the DB from 11.2..0.1.0 to after which my queries started giving ORA:01722 error.


The query had a left outer join between two tables based on the 2 column having different data types.


For eg:  select * from table_1left outer join table_2 on table_2.column with number data type =

               table_1. column with varchar datatype


This query was working fine on 11.2..0.1.0, but started to give out error  after upgrading.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points