to_number function and the "invalid number" error
CrusoeMar 23 2010 — edited Mar 23 2010Dear all,
I have searched the forum for threads relating to the ORA-01722: invalid number error, could not find the answer I am looking for.
What I was trying to do was
select * from table1 where to_number(field1) > 1000
field1 is a varchar2 data type.
I tried all sorts of things i.e using fmt, nls params as defined in the documentation, nothing worked.
Though the practical problem was solved by
select * from table1 where field1 > '1000'
I would still like to know why this error occurs. Can someone help ?
Regards
Crusoe