ORA-01722: invalid number
Posted: Mon Jun 15, 2009 9:34 am
Hellooo Gurus!
I have a query that is just driving me crazy..
i have a varchar2 column that am trying to convert to a number using the "to_number" function. when I do the conversion in the select , it's just working fine, but when am using it in the where-clause, it gives me the following error:
ORA-01722: invalid number
ex:
where to_number(a.argument1) >1
i am using this query in a report of mine, is there any way i can overcome this error by using PL/SQL functions? if yes, plz clarify cuz am new to Oracle reports
thanks a million
I have a query that is just driving me crazy..
i have a varchar2 column that am trying to convert to a number using the "to_number" function. when I do the conversion in the select , it's just working fine, but when am using it in the where-clause, it gives me the following error:
ORA-01722: invalid number
ex:
where to_number(a.argument1) >1
i am using this query in a report of mine, is there any way i can overcome this error by using PL/SQL functions? if yes, plz clarify cuz am new to Oracle reports
thanks a million