My Oracle Support Banner

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 later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
APEX Application Development - Version NA and later
Information in this document applies to any platform.


Trying to export an application following
Getting errors for One Particular Application (it works for other)

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)


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.