MarkView All Components - Troubleshooting Oracle ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Summary
4900
Applies To
- ERP System: Oracle, SAP, Peoplesoft
- MarkView Version: All Versions
Behavior
- In certain situations the following error may occur
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Known Causes
- Standard Oracle error message indicating an Oracle statement resulted in an arithmetic, numeric, string, conversion, or constraint error.
Resolution
- If an ORA-06502 error occurs and it is not clear where the error is coming from you can follow the steps in Oracle Support Note 139548.1 on a quiet system and reproduce the issue. Once the issue is reproduced you should be able to upload the resulting raw trace file and tkprof output which will help isolate the statement generating the 06502 error.
- How to Determine the Cause of ORA-6502 Errors [ID 139548.1]
- Master Note for Diagnosing ORA-06502 Error [ID 1137237.1]
Keywords: 06502, pl-sql