Re: ORA-01722: invalid number

Comments embedded.
ampierce wrote:
> HELP! Okay, I am doing a simple update statement in which I take a
> decimal field and multiply it by an integer field to populate into a
> decimal field. Here is my example:
>
> update tts_hlpdsktkt_acq_quotelines
> set extprice = numberofitems*unitprice
> where ttstktacqquotelineid = '000000000126090'
>
> in my database, the extprice is a decimal field, as well as the
> unitprice, the numberofitems is an integer field.
>
> I only receive the error if unitprice is over 999. Seems like a "," is
> getting put in there somehow and it is causing the statement to error
> out.
>

That can't be, as NUMBER fields don't store formatting information, only the decimal should there be need for one.

Without seeing samples of your errant data any assistance would be mere speculation, and likely not worth the effort.

> Any ideas?

Provide data samples of the problem entries.

David Fitzjarrell Received on Thu Sep 22 2005 - 11:07:58 CDT