APEX_SESSION.ATTACH

APEX_SESSION

ATTACH Procedure

In my previous blog , I have shared the way to query APEX_COLLECTIONS data from database backend itself. That approach needs to follow three steps.

  • Setting up Workspace
  • Setup Application ID
  • Setup Session id

Today let’s explore the APEX_SESSION API. And specifically ATTACH procedure. Which is helpful to achieve the same.

Purpose:

This procedure based on the given application and session current, sets environment and runs the Initialization PL/SQL Code.

BEGIN
   apex_session.attach (p_app_id       => 177, --  Application ID
                        p_page_id      => 5, -- Page ID
                        p_session_id   => 19278163964528 -- Session ID
						);
END;

After executing the ATTACH procedure we can query the APEX collections from back end and also we can Access the Page ITEM Values

QUERY the APEX_COLLECTIONS

SELECT * FROM apex_collections 
	where collection_name= 'TEST';

Access APEX page Items

SELECT v('P5_ITEM') FROM dual;

DETACH Procedure

This procedure detaches from the current session, resets the environment and runs the application’s Cleanup PL/SQL Code. This procedure does nothing if no session is attached.

begin
    apex_session.detach;
end;

Other Useful Links