-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|