Oracle9iAS Portal Developer Kit

drop_session procedure

Contained in package wwa_api_module_session.

Call this procedure to permanently remove form component session data from the database.

This procedure first tries to load the session for the ID specified and then deletes the session data from the database.

static procedure drop_session
(
    p_id in integer
),

Version: Oracle Portal 3.0.9

Parameters:

p_id

The ID of the form component session to be deleted.

Datatype: integer

Exceptions:

If you try to delete a form session that does not exist, or does not belong to your Login session, the NO DATA FOUND exception is raised and propagated to the caller.

Example:

Consider a form component session (id = 77) created and stored in the database using create_session. To drop this session data:

begin
    <portal_schema>.wwa_api_module_session.drop_session
    (

        p_id => 77

    );

end;

Related topics

The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio