4 Replies Latest reply: Jul 11, 2013 6:15 PM by learner1 RSS

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




      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.