SET_SESSION_STYLE Procedure

57.7 SET_SESSION_STYLE Procedure

This procedure sets the theme style dynamically for the current session. This is typically called after successful authentication.

Syntax

APEX_THEME.SET_SESSION_STYLE (
    p_application_id  IN NUMBER DEFAULT {current application id},
    p_theme_number    IN NUMBER DEFAULT {current theme number},
    p_name            IN VARCHAR2 );

Parameters

Parameter	Description
`p_application_id`	The application ID. Default is the current application.
`p_theme_number`	The theme number to set the session style for. Default is the current theme of the application.
`p_name`	The name of the theme style to be used in the session.

Example

The following example gets the current theme number from Oracle APEX Dictionary View and sets the session theme style for the current theme to Vita.

DECLARE
    l_theme_number number;
BEGIN
    SELECT theme_number
      INTO l_theme_number
      FROM apex_application_themes

     WHERE application_id = :APP_ID;
     apex_theme.set_session_style (
        p_theme_number => l_theme_number,
        p_name         => 'Vita' );
END;

Parent topic: APEX_THEME