APEX_REGION.EXPORT_DATA Gives Error ORA-1403: No Data Found when exporting from an IG
(Doc ID 2858613.1)
Last updated on MARCH 27, 2022
Applies to:
Oracle Application Express (APEX) - Version 21.2 and laterAPEX Application Development - Version NA and later
Information in this document applies to any platform.
Symptoms
On : APEX 21.2 version, Flow Builder
When attempting to use APEX_REGION.EXPORT_DATA API
the following error occurs.
ERROR
-----------------------
ORA-1403: no data found
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter this code either in a form or in a test PLSQL block
2. The l_page_id and l_region_id are valid values as seen in apex_appl_page_ig_rpt
3. Get the error instead of expected result as in previous APEX version
Changes
Upgrade APEX to 21.2
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 |
| Changes |
| Cause |
| Solution |
| References |