ORA-01722: invalid number

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
Racleoay
Posts: 26
Joined: Thu May 08, 2008 8:20 am
Location: United Arab Emirates

ORA-01722: invalid number

Post by Racleoay »

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
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests