ORA-6502: numeric or value error?

[Happosai]

Hi,

I'm trying to use a stored procedure through OO4O and I keep getting ORA-6502 errors. I know it is defined as numeric or value error, but I don't know what could cause it. Can someone specify this error?

Thanks,

Tuomo Mikola

[nealh]

The most likely cause is that you're trying to assign a variable to something which is too long e.g. trying to put 6 characters into a varchar2(5) column or 999 into a number(2) column.

[nealh]

Can also occur if you try to assign a character string to a number or vice versa. Normally, Oracle will try to convert to the correct data type but, if it can't, you will get an error.

[romulofbp]

Dear Tuomo Mikola,

This is error can also occurs when you try to assign the value NULL to a variable declared NOT NULL.

Hugs,

Rômulo.