How to Accomplish a Timeout After 15 Minutes of User Inactivity within APEX for Long Running Query or Report
(Doc ID 2401459.1)
Last updated on FEBRUARY 18, 2021
Applies to:Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Application Express (APEX) - Version 5.1.3.00 to 5.1.4.00.08 [Release 5]
Information in this document applies to any platform.
The APEX_UTIL.SET_SESSION_MAX_IDLE_SECONDS is set to 900 ( 15 minutes). A long running report runs for approximately 30 minutes. This long running report (or page query) fails with a timeout. Is it possible to set the time out in such a way that the maximum idle time in APEX does not affect long running reports? This concept is similar to FORMS_TIMEOUT, which allows a query to complete before the timer for the "time out" setting starts.
Is there any way to accomplish this in APEX?
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