APEX 20.2
I have created a login page using custom authentication. When a valid username & password is entered I am wanting a modal dialog form(page# 9900) to appear. When the user clicks ok, the home page is then shown. If the user clicks on cancel or closes the modal dialog form the home page is not shown and the user is logged out of the application.
In page # 1, I have created a pre-rendering -> before Header -> processes
DECLARE
l_url varchar2(2000);
l_app number := v('APP_ID');
l_session number := v('APP_SESSION');
BEGIN
l_url := APEX_UTIL.PREPARE_URL(p_url => 'f?p=' || l_app || ':9900:'||l_session||'::NO::P9900_NEW:xyz', p_checksum_type => 'SESSION');
END;
The before header process is run, but the modal dialog does not appear. It goes straight to page 1.
How do you get a modal dialog to appear after the login page ?