4 Replies Latest reply: Jul 11, 2013 6: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

      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.