Originally posted by raf
I get this query:
where col > 6
group by col
when I get on instance x it run correctly, but when I get on instance y I get error ora-01722.
datatype of col is varchar2(32)
If col is a VARCHAR2 then you should not be comparing it to a NUMBER!
What is happening is that Oracle is casting col to NUMBER to do the comparison (i.e. doing TO_NUMBER(col)). In instance x there are no values in col that cannot be cast to NUMBER, but in instance y there are.