How To Avoid Endless Loop in Run_Report_Object Code (Doc ID 405888.1)

Last updated on OCTOBER 09, 2023

Applies to:

Goal

You have programmed a code like below, e. g. in a when-button-pressed trigger. Now you realized that there could an endless loop occur. If something fails from the Reports Server side  for example with an error message: Failed Job, then this loop may continue with this code:

...

rep_status: = REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status: = REPORT_OBJECT_STATUS(v_rep);
END LOOP;
...

How to avoid an endless loop (The failed job is not in 'RUNNING', 'OPENING_REPORT', 'ENQUEUED.)?

Solution

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