ORA-6502: numeric or value error?

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

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.

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.

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.