Displaying a Progress bar during slow PLSQL Region Output
PaulPJun 14 2011 — edited Jun 14 2011I have a page with a single PLSQL region which take a while to generate its HTML output. Anytime the user navigates to this page I would like them to see a progress bar appearing until the region's output is generated.
I have tried to implement Tobias Arnhold's plug-in solution at
http://www.apex-plugin.com/oracle-apex-plugins/dynamic-action-plugin/loading-icon_81.html
but I can't get it to work the way I would like it to. I'm open to other suggestions. I am not sure of the Events that need to be used in the advanced dynamic action. Page Load seems to execute AFTER the page has loaded. Page Unload ??not sure when this fires. The region refresh events only work with PPR on Interactive or normal SQL reports NOT PLSQL regions. IS that right?
Here is my proposed sequence of events:
Page 1 -->click on button-->leave page 1-->Page 2 starts to load-->POPUP "Loading..."message -->PLSQL Region OUTPUT appears -->"Loading..." message disappears.
Any help here is much appreciated.
regards
Paul P