Idea Summary
Allow developers to run pl/sql code as a session is being cleaned up by APEX (upon logout or session expire). For example, if I have a table that is similar to apex_collections or apex_application_temp_files, my_session_data, I would want to run
delete from my_session_data
where apex_session = :APP_SESSION;
at the same time that APEX deletes data from apex_collections and apex_application_temp_files.
Use Case
For example, if I have my own table (not a collection):
my_shopping_cart
session_id number,
item_id number,
item_desc varchar2(200)
...
I want to have a procedure
procedure my_cleanup(p_app_session_id in number) is
begin
delete from my_shopping_cart
where session_id = p_app_session_id;
end;
Preferred Solution (Optional)
Implement this either as an application process point or in similar fashion to similar to “Cleanup PL/SQL Code”, for example as “Logout / Session Expire PL/SQL Code.”