APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best Practice for Dynamically Changing Theme Style in Oracle APEX using APEX_THEME.SET_CURRENT_STYLE

Harsh PanchalMay 16 2025 — edited May 20 2025

Hi all,

I'm trying to dynamically change the theme style in Oracle APEX at runtime using the APEX_THEME.SET_CURRENT_STYLE procedure. Here's my full setup:

🔧 Setup Details

✅ Page Item:
Created a select list item P0_THEME_STYLE on the Global Page (Page 0).

✅ SQL Query for Select List:
SELECT s.name d, s.theme_style_id r
FROM apex_application_theme_styles s,
apex_application_themes t
WHERE s.application_id = t.application_id
AND s.theme_number = t.theme_number
AND s.application_id = :APP_ID
AND t.ui_type_name = 'DESKTOP'
AND t.is_current = 'Yes'
ORDER BY 1

✅ Source (Return Single Value SQL Query):
SELECT s.theme_style_id
FROM apex_application_theme_styles s,
apex_application_themes t
WHERE s.application_id = t.application_id
AND s.theme_number = t.theme_number
AND s.application_id = :APP_ID
AND t.ui_type_name = 'DESKTOP'
AND s.is_current = ‘Yes’

✅ Server-side Condition (Row Exists):
SELECT 1
FROM apex_application_theme_styles s,
apex_application_themes t
WHERE s.application_id = t.application_id
AND s.theme_number = t.theme_number
AND s.application_id = :APP_ID
AND t.ui_type_name = 'DESKTOP'
AND t.is_current = 'Yes'

⚙️ Dynamic Action on Change (PL/SQL Code):
IF :P0_THEME_STYLE IS NOT NULL THEN
FOR c1 IN (
SELECT theme_number
FROM apex_application_themes
WHERE application_id = :APP_ID
AND ui_type_name = 'DESKTOP'
AND is_current = 'Yes'
) LOOP
apex_theme.set_current_style(
p_theme_number => c1.theme_number,
p_id => :P0_THEME_STYLE
);
END LOOP;
END IF;