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  11.2.0.1.0 to  11.2.0.2.0

955210 Newbie
Currently Being Moderated

Hi,

 

Recently i upgraded the DB from 11.2..0.1.0 to 11.2.0.2.0 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.

Legend

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