17 APEX_PLSQL_JOB

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.

Topics:

• About the APEX_PLSQL_JOB Package

• JOBS_ARE_ENABLED Function

• PURGE_PROCESS Procedure

• SUBMIT_PROCESS Function

• TIME_ELAPSED Function

• UPDATE_JOB_STATUS Procedure