[raf]

hi,
I get this query:
select col
from tab
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)


Raf

[andrewst]

Originally posted by raf
hi,
I get this query:
select col
from tab
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)


Raf

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.