Hi everyone,
I'm currently developing an Oracle APEX application and I'm facing an issue on one of my app pages where the following error is thrown:
ORA-06502: PL/SQL: numeric or value error
Display Location: INLINE_IN_NOTIFICATION
Issue Details:
- The error appears when I try to [e.g., submit a form / update a record / call a process].
- I have double-checked the data types in the table and the items in the form, and I don’t see any obvious mismatches.
- There’s no clear indication of which field or value is causing the issue.
- This happens even when I enter what seems like valid data.
Things I’ve Tried:
- Verified column lengths in DB match APEX item lengths.
- Checked any
TO_NUMBER, TO_CHAR, or casting in PL/SQL processes.
- Tried using
DBMS_OUTPUT.PUT_LINE to trace, but I still couldn’t pinpoint it.
Questions:
- What are some reliable ways to debug this kind of error in APEX?
- How can I identify exactly which item or process is causing the value or numeric error?
- Is there a common mistake in Dynamic Actions or PL/SQL processes that might trigger this?
Environment Info:
- Oracle APEX version: [insert version, e.g., 23.1]
- Database version: [e.g., Oracle 19c]
- App is hosted on: [e.g., apex.oracle.com / local instance]
Would really appreciate any guidance or steps to trace this error more effectively. Thank you in advance!