29 APEX_SESSION

This procedure creates a new session for the given application, set environment and run the application's Initialization PL/SQL Code.

Syntax

procedure create_session (
   p_app_id in number,
   p_page_id in number,
   p_username in varchar2 );

Parameters

Raises

WWV_FLOW.APP_NOT_FOUND_ERR: The application does not exist or the caller has no access to the workspace.

Example

This example creates a session for EXAMPLE USER in application 100 page 1, then print the app id and session id.

begin
    apex_session.create_session (
    p_app_id   => 100,
    p_page_id  => 1,
    p_username => 'EXAMPLE USER' );
    sys.dbms_output.put_line (
   'App is '||v('APP_ID)||', session is '||v('APP_SESSION'));
 end;

This procedure deletes the session with the given ID. If the session is currently attached, call the application's Cleanup PL/SQL Code and reset the environment. This procedure does nothing if the given session does not exist or if the caller can not access the session's workspace.

Syntax

procedure delete_session (
    p_session_id in number default wwv_flow.g_instance );

Parameters

Raises

Example

Delete session 12345678.

begin
    apex_session.delete_session (
    p_session_id => 12345678 );
 end;

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

Syntax

procedure attach (
    p_app_id     in number,
    p_page_id    in number,
    p_session_id in number );

Parameters

Raises

Example

Attach to session 12345678 for application 100 page 1, then print the app id and session id.

begin
    apex_session.attach (
        p_app_id     => 100,
        p_page_id    => 1,
        p_session_id => 12345678 );
    sys.dbms_output.put_line (
        'App is '||v('APP_ID)||', session is '||v('APP_SESSION'));
end;

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.

Syntax

procedure detach;

Example

Detach from the current session..

begin
    apex_session.detach;
end;