6.38 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
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

See Also:

GET_KEEP_SESSIONS Function