My Oracle Support Banner

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.

Goal

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?
 

Solution

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
Goal
Solution


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