How Execute Procedure / Trigger in APEX at a Regular Interval
(Doc ID 1494145.1)
Last updated on AUGUST 21, 2019
Applies to:Oracle Application Express (APEX) - Version 4.0.0 to 4.1.1.00.23 [Release 4]
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
We have an application where we would like to periodically refresh the data in the underlying tables after a certain period of time (5 minutes). Once the refresh has taken place, we would like to refresh the information on the APEX page to reflect the changes.
1. Is there any way to execute the procedure in regular intervals in APEX?
2. Using DBMS_JOB package we can execute the procedure but is this suits for this kind of requirements or there any other methods available?
3. After executing the procedure is it possible to refresh the APEX page? If yes how this can be achieved? Is there any sample code available?
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