Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Jake4321Jun 18 2020 — edited Jun 19 2020

Hi all,

This error just popped up in our production environment and only on 1 specific row, on other rows, it works just fine no errors and it performs all it is meant to do very well (updates, inserts, display).

My PL/SQL code is "instrumented" thoroughly with logger logs so I know when each PLSQL code starts, ends and bombs out (exceptions when other then log it).

But, I have this error 1 error I have no clue how to troubleshoot.

QUESTION: How do I go about troubleshooting this "debug" dump? Is there any documentation on how to read those dumps.

In the good old days, 360-370, we would have memory dumps. Some though it was magic to find our way through tens of pages of 0-9 A-F but NO! it was an exact science, we could pinpoint exactly what instruction failed and what operands where used at what line in the code.

Any tips, comments, suggestion greatly appreciated

Thanks,

Jake

pastedImage_0.png

This post has been answered by fac586 on Jun 18 2020
Jump to Answer
Comments
Post Details
Added on Jun 18 2020
11 comments
27,676 views