40.7 SET_SESSION_STYLE Procedure

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

Syntax

PROCEDURE SET_SESSION_STYLE (
    p_theme_number  IN NUMBER           DEFAULT {current theme number},
    p_name          IN VARCHAR2
); 

Parameters

Table 40-7 SET_SESSION_STYLE Procedure

Parameter	Description
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 Application Express Dictionary View for the DESKTOP user interface.

select t.theme_number
  from apex_application_themes t
 where t.application_id = :app_id
   and t.ui_type_name = 'DESKTOP'

The following example sets the session theme style for the current theme to Vita.

apex_theme.set_session_style (
     p_theme_number => {query.theme_number},
     p_name => 'Vita'
);