![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_APEX-logo.jpg\"){kind=logo}
<\/p>\n<\/p>\n
This blog will explain how to proceed in order to redirect all the application pages to one single page, prior to their processing and rendering, with Oracle APEX 4.0 and above.<\/p>\n
In some cases, like security checks, you may want to redirect all calls of any page in your APEX application to one single page whith particular processing before the target page is rendering or even processing.<\/p>\n
I ran into this need again, recently while developing some application.<\/p>\n
Application user has to change his password after first login or password reset. No other page than password change should be accessed until successful change. This page is part of standard administration, as user can also choose to change his password at any time. It therefore contains already links to navigate within the application, which needs to be prevented. In addition any page call within the application, from direct URL entry, must be prevented as well (no cheating allowed).<\/p>\n
Natural answer would be Page 0, also known as Global Page.<\/p>\n
So what? Let’s put some branch into the ‘Before Header’ part of the global page, which would redirect as soon as any page rendering starts, preventing the display of the current page.<\/p>\n
Unfortunately, this doesn’t work…<\/p>\n
Why? Simply because APEX doesn’t handle it. The first indicator is that you can’t access any branching in the ‘Before Header’ section of the global page, unlike any normal page.<\/p>\n
You have to trick, using the ‘Create – Add a page control to this page’ wizard, to add such kind of branching. So, you shouldn’t do it…<\/p>\n APEX offers another nice feature called by any page of the application: Application Processes<\/strong>.<\/p>\n And that’s the key. The branching is not happening as easy as when done declaratively in a page, but adding those few lines of PL\/SQL in the process will make it:<\/p>\n htp.init; In order to work you also need to tell him when to run. In our case ‘On Load: Before Header (page template header)’.<\/p>\n This application process will do the job and even overeager, because the target page itself will loop into death. So you need to set some condition on that process, in order to NOT call it when the current page is the target page. In my case I have also added the login page of the application as user is allowed to get back to it even though the password was not changed. In order to combine condition related to page and user state verification, execution of the application process is linked to the result of a function returning a boolean.<\/p>\n Below the code of the function called. To make it nice and avoid having hard coded page numbers, you can use page aliases and retrieve the page number as shown:<\/p>\n FUNCTION is_change_password_required — Check if current page is Login or change password IF v_found > 0 THEN<\/span> I hope you will enjoy this solution for your own password change management or other purpose.<\/p>\n","protected":false},"excerpt":{"rendered":" This blog will explain how to proceed in order to redirect all the application pages to one single page, prior to their processing and rendering, with Oracle APEX 4.0 and above. In some cases, like security checks, you may want to redirect all calls of any page in your APEX application to one single page […]<\/p>\n","protected":false},"author":17,"featured_media":3647,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[304,436,437,438,439],"type_dbi":[],"class_list":["post-3646","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-integration-middleware","tag-apex","tag-before","tag-global-page","tag-redirection","tag-rendering"],"acf":[],"yoast_head":"\n![\"GlobalPage_NoBranch_Compare\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/GlobalPage_NoBranch_Compare.png\")
<\/em><\/p>\nWhat else can we do?<\/h3>\n
\n\u00a0 owa_util.redirect_url(‘f?p=&APP_ID.:CHGPWD:&SESSION.’);<\/span>
\napex_application.stop_apex_engine;
<\/span><\/span><\/p>\n![\"ApplicationProcess_start_point\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ApplicationProcess_start_point.png\")
<\/p>\n![\"Condition\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Condition.png\")
<\/p>\n
\nRETURN BOOLEAN IS
\nv_username VARCHAR2(30);
\nv_chg_pwd_required BOOLEAN;
\nv_found NUMBER;
\nBEGIN
\nv_chg_pwd_required := TRUE;
\nv_username := NVL(v(‘APP_USER’), USER);<\/p>\n
\n— to enforce login and avoid looping on change password
\nSELECT COUNT(*) INTO v_found
\n\u00a0\u00a0\u00a0\u00a0\u00a0 FROM apex_application_pages
\n\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE application_id = v(‘APP_ID’)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND page_id = v(‘APP_PAGE_ID’)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND page_alias IN (‘LOGIN’, ‘CHGPWD’);<\/span><\/span><\/span><\/span><\/span><\/p>\n
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 v_chg_pwd_required := FALSE;<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 ELSE<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 v_chg_pwd_required := is_new_or_reset_password(v_username);<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 END IF;<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 RETURN v_chg_pwd_required;<\/span>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>
\n\u00a0\u00a0\u00a0 END is_change_password_required;<\/span><\/p>\n