Hi,
Using Oracle APEX 4.2, I have a page process that uses DBMS_ALERT for a running process that may take up to a minute to complete or fail.
While this is running, through the use of a trigger, there is a DBMS_ALERT.signal posting notifications of progress.
My question is, within Oracle APEX 4.2, how can I display to the user, a running progress of these notifications from DBMS_ALERT, within a region or modal on the page?
I need to provide the user all these alerts as the job is running until it finally completes.
For example:
Started Job...
Waiting on resources...
Processing job...
Job completed successfully.
Obviously through each of these DBMS_ALERTS, there may be a few seconds before each line is presented to the user.
Just unsure how to grab these alerts and show the user, within Oracle APEX.
Thanks.
Tony.