Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to show progress in a page for a process?

AllenS.Nov 23 2023 — edited Nov 23 2023

Hi,

Using APEX 18.2, I have a page that populates a collection on load thru for i in select statement loop then add_member to collection. This actually takes a while and I want to show the users some sort of progress that the application is actuall doing something backend. Is there any way to show the progress in the page?

The process that populates the collection is thru DA page load sequence 1. Then I created another process to check the number of data in the collection vs total result of the query on another DA page load but then I realized that these are execute in sequence and not parallel.

Does apex has any build it feature for this?

EDIT: I tried using application process Ajax Callback for populating the collection and calls this on a DA in the page. I then have an Interactive Report on the page that queries the collection. For some reason, the IR does not show any data until the application process is done. I was hoping to get the latest data here every time I refresh but doesn't seem to work that way.

Thanks,

Allen

Comments
Post Details
Added on Nov 23 2023
0 comments
399 views