Access APEX collection data from apex_collection view from SQL Developer/Toad.
declare
v_ws_id apex_workspaces.workspace_id%TYPE; -- Workspace ID
v_app_id NUMBER := 136; -- APEX Application ID
v_session_id NUMBER := 8918238931; -- APEX Application session ID
begin
select max (workspace_id)
into v_ws_id
from apex_applications
where application_id = v_app_id;
wwv_flow_api.set_security_group_id (v_ws_id);
APEX_APPLICATION.g_flow_id := v_app_id;
APEX_APPLICATION.g_instance := v_session_id;
END;
Why do you want to access from the backend the temp data which can change any time?
Based on requirement. Data can be changed from APEX session also.
Sometime inside PLSQL API need to access collection data for DML operation.