You can use APEX_PLSQL_JOB package to run PL/SQL code in the background of your application. This is an effective approach for managing long running operations that do not need to complete for a user to continue working with your application.
APEX_PLSQL_JOB
Topics:
About the APEX_PLSQL_JOB Package
JOBS_ARE_ENABLED Function
PURGE_PROCESS Procedure
SUBMIT_PROCESS Function
TIME_ELAPSED Function
UPDATE_JOB_STATUS Procedure
Scripting on this page enhances content navigation, but does not change the content in any way.