APEX_EXPORT.GET_APPLICATION Fails With Error ORA-06502
(Doc ID 2876886.1)
Last updated on JUNE 14, 2022
Applies to:
Oracle Application Express (APEX) - Version 21.1 and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
APEX Application Development - Version NA and later
Information in this document applies to any platform.
Symptoms
Trying to export an application following https://docs.oracle.com/en/database/oracle/application-express/21.1/aeapi/GET_APPLICATION_Function.html#GUID-A8E626D6-D7DE-4E59-8F90-3666A7A41A87
Getting errors for One Particular Application (it works for other)
ERROR
-----------------------
declare
*
ERROR at line 1: [ERROR on row 1]
ORA-06502: PL/SQL: Number or Value Error [error of number or value]
ORA-06512: a "APEX_210100.WWV_FLOW_EXPORT_API", line 117
ORA-06512: a "APEX_210100.WWV_FLOW_GEN_API2", line 9657
ORA-06512: a "APEX_210100.WWV_FLOW_GEN_API2", line 3283
ORA-06512: a "APEX_210100.WWV_FLOW_GEN_API2", line 3283
ORA-06512: a "APEX_210100.WWV_FLOW_GEN_API2", line 9578
ORA-06512: a "APEX_210100.WWV_FLOW_GEN_API2", line 9578
ORA-06512: a "APEX_210100.WWV_FLOW_EXPORT_INT", line 275
ORA-06512: a "APEX_210100.WWV_FLOW_EXPORT_API", line 70
ORA-06512: a line 4
The single application is not able to export at all, not even in the APEX Builder GUI (returning the same error)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |