ORA-01722 error

Hi,
I have a condition in my query which gives me this error:
ORA-01722: invalid number.
The column which gives this error contains both numeric as well as character data. Any clue?


BOisBest :india: (BOB member since 2004-04-05)

Anita,

What is the condition?
Check these links out, may be you get some help.

http://www.orafaq.com/error/ora-01722.htm

kashif


Kashif Saeed :pakistan: (BOB member since 2004-06-02)

i have a prompt which accepts code for part number which could be numeric as well as char.


BOisBest :india: (BOB member since 2004-04-05)

The filed what ever you are talking is coming from a database right, then it can either be char or numeric, not otherwise


Bobby (BOB member since 2004-05-05)

Thanks Saeed
That was helpful. Actually there was one unnecessary join which was trying to match a numeric value with char value. i got rid of that.


BOisBest :india: (BOB member since 2004-04-05)