SET_KEEP_SESSIONS Procedure

8.44 SET_KEEP_SESSIONS Procedure

This procedure preserves sessions associated with the application on upgrades.

Syntax

procedure SET_KEEP_SESSIONS (
    p_keep_sessions IN BOOLEAN );

Parameters

Parameter Description

Parameter	Description
`p_keep_sessions`	Default `FALSE`. If `FALSE`, sessions are deleted. If `TRUE`, sessions are preserved. `KEEP_SESSIONS_ON_UPGRADE` controls the default behavior. If `N` (default), sessions are deleted. `KEEP_SESSIONS_ON_UPGRADE` is an instance parameter.

p_keep_sessions

Default FALSE. If FALSE, sessions are deleted.

If TRUE, sessions are preserved.

KEEP_SESSIONS_ON_UPGRADE controls the default behavior. If N (default), sessions are deleted. KEEP_SESSIONS_ON_UPGRADE is an instance parameter.

Example

The following example installs application 100 in workspace FRED_PROD and keeps session state.

BEGIN
  apex_application_install.set_workspace(p_workspace => 'FRED_PROD');
  apex_application_install.set_keep_sessions(p_keep_sessions => true);
END;
/
@f100.sql