Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle VALUE_ERROR Exception - ORA-06502      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: VALUE_ERROR

Definition:
VALUE_ERROR exception (ORA-06502) occurs when an arithmetic, conversion, truncation, or size-constraint error occurs. For example, when a program selects a column value into a character variable, if the value is longer than the declared length of the variable, PL/SQL aborts the assignment and raises VALUE_ERROR. In procedural statements, VALUE_ERROR is raised if the conversion of a character string into a number fails. (Note that in SQL statements, INVALID_NUMBER is raised.)

 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 85 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?