Environment:
- Oracle APEX 24.1.0
- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
Issue:
When I attempt to export my APEX application (Application ID 109) via the command line or the APEX interface, I receive the following error:
```
Error exporting flow 109. ORA-06502: PL/SQL: numeric or value error
ORA-06502: PL/SQL: numeric or value error
```
What I’ve Tried:
- Checked the size of LOVs, computations, and processes to ensure none exceed 3900 characters.
- Reviewed recent changes to the application for any unusually large text or numeric values.
- Verified that no columns or attributes have values that exceed their defined limits.
Question:
- Is there a systematic way to identify which component (e.g., LOV, computation, process, page item, etc.) is causing the numeric or value error during export?
- Are there logs, debug settings, or export options in APEX 24.1.0 that can help pinpoint the problematic object or value?
- Has anyone encountered this error in a similar context, and what steps did you take to resolve it?
Any advice or troubleshooting steps would be greatly appreciated.