DELETE_SESSION Procedure

36.4 DELETE_SESSION Procedure

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.

Syntax

PROCEDURE DELETE_SESSION (
    p_session_id IN NUMBER DEFAULT apex_application.g_instance );

Parameters

Table 36-3 DELETE SESSION Procedure Parameters

Parameters	Description
`p_session_id`	The session id.

Raises

APEX.SESSION.EXPIRED: The session does not exist.
SECURITY_GROUP_ID_INVALID: Current workspace does not match session workspace.

Example

Delete session 12345678.

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