3.12 GET_KEEP_SESSIONS Function

This function finds out if sessions and session state will be preserved or deleted on upgrades.

Syntax

function get_keep_sessions
    return boolean

Example

The following example shows whether print sessions will be kept or deleted.

dbms_output.put_line (
    case when apex_application_install.get_keep_sessions then 'sessions will be kept'
    else 'sessions will be deleted'
    end );