- Oracle-Developer.com -

Navigation: Home  | Discussion Forums (Get expert advice)  |  Scripts  |  About Us  | Links  | Job Openings  
ORA-06502 PL/SQL: numeric or value error string
Comment on this Topic


ORA-06502 PL/SQL: numeric or value error string

Cause: 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).

Action: Change the data, how it is manipulated, or how it is declared so that
values do not violate constraints.


Comment on ORA-06502 PL/SQL: numeric or value error string

 

Owned and Operated by Varun Jain, Inc, an Oracle Consulting Firm

Copyright ©2007 Oracle-Developer.com