Kbase P54624: Error calling Oracle stored procedure ORACLE error 6502
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/18/2003 |
|
Status: Unverified
SYMPTOM(s):
Error calling Oracle stored procedure ORACLE error 6502 see "ORACLE Error Messages and Codes Manual". (1252)
ORA-06502 PL/SQL: numeric or value error
CAUSE:
You stored procedure has 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).
FIX:
Review and change your stored procedure code by change the data, how it is manipulated, or change how it is declared so that values do not violate constraints.