ORA-06502 PL/SQL: numeric or value error string
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-06502 from Oracle 8i ?
An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).
How to deal with ORA-06502 from Oracle 8i ?
Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-06500 PL/SQL: storage error
- ORA-06501 PL/SQL: program error
- ORA-06503 PL/SQL: Function returned without value
- ORA-06504 PL/SQL: Return types of Result Set variables or query do not match
- ORA-06505 PL/SQL: variable requires more than 32767 bytes of contiguous memory
- ORA-06508 PL/SQL: could not find program unit being called
- ORA-06509 PL/SQL: ICD vector missing for this package
- ORA-06510 PL/SQL: unhandled user-defined exception