Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle Database Error: ORA-06502      [Return To Oracle Error Index] Jump to:  
Oracle Error: ORA-06502

Error Description:
PL/SQL: numeric or value error

Error Cause:
A statement was executed that resulted in an arithmetic, numeric, string, conversion, or constraint error. This error mainly results from programmer error or invalid data input. For example:

SQL> DECLARE
  2    i NUMBER;
  3  BEGIN
  4    i := ' ';
  5  END;
  6  /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 4

This error may also occur 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 999 to a variable declared NUMBER(3), or if an attempt is made to assign more than 5 characters to a VARCHAR2(5) variable.

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


There haven't been any comments added for this error yet. You may add one if you like.  Add a comment 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 225 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?