ORA-6502: numeric or value error?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-6502: numeric or value error?

  1. #1
    Join Date
    Apr 2001
    Posts
    13

    Question

    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

  2. #2
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    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.


  3. #3
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    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.

  4. #4
    Join Date
    Oct 2001
    Posts
    23
    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
  •  



Click Here to Expand Forum to Full Width