Access APEX collection data from SQL Developer

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;

Leave a Reply

Your email address will not be published. Required fields are marked *