DELETE_SESSION Procedure

44.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

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

Parameters

Table 44-3 DELETE SESSION Parameters

Parameters	Description
`p_session_id`	The session ID.

Raises

APEX.SESSION.EXPIRED: Your session has ended.
SECURITY_GROUP_ID_INVALID: Security Group ID (your workspace identity) is invalid.

Example

The following example deletes session 12345678.

BEGIN
    apex_session.delete_session (
    p_session_id => 12345678 );
END;