ORA-1722 "Invalid Numer" error

[JJPA]

Hi,

I'm using a Pro*C program which has a SELECT FOR UPDATE statement. I'm moving the ROWID that I selected in the statement into a hostvariable. Then when I do the UPDATE for the ROWID, I'm getting ORA-1722 error. How is this possible?

Also some people have notified this error is randomly occuring in our applications. Do you think something might be wrong with our database?

I appreciate any help in this matter.

Thanks.

 

[karluk]

From the type of error you are getting, it certainly sounds as if you are supplying nonnumeric values to update a numeric column. Can you double check which columns are numeric and what values you are supplying for the update?

 

[JJPA]

Thanks, Karluk for responding. It is not necessarily an update that is giving the problem. But even simple selects with just 1 check on the where clause (for eg. where card_num = :host_card_num) is giving the same error.

Any help is greatly appreciated.

Thanks.

 

[karluk]

You need to check the value of host_card_num at execution time. It appears to not evaluate to a numeric value. Maybe your application code hasn't assigned it a value.