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 (BOB member since 2004-04-05)
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 (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 (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 (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 (BOB member since 2004-04-05)