My Oracle Support Banner

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 later
APEX 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


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