Posted on Saturday, November 13, 2010 Nicer APEX Login Category APEX Tips and Tricks Everybody thought of a nicer login in APEX web applications. Here is one example on how to make it a bit Nicer. This applies to EPG environment. If you want to make it working under different environment, please refer to OHS instructions for configuring, or APEX Listener configuration. You can create procedure like this to redirect to your application: create or replace PROCEDURE MYAPP AS BEGIN f (p=>'100:101'); APEX_UTIL.SET_SESSION_STATE ('FSP_AFTER_LOGIN_URL'); END; Change application id and page id accordingly in procedure. Give grant to execute this procedure to public and create public synonym for it. Modify APEX schema wwv_flow_epg_include_mod_local function so that you can execute that procedure in URL: create or replace function wwv_flow_epg_include_mod_local( procedure_name in varchar2) return boolean is begin --return false; -- remove this statement when you modify this function -- -- Administrator note: the procedure_name input parameter may be in the format: -- -- procedure -- schema.procedure -- package.procedure -- schema.package.procedure -- -- If the expected input parameter is a procedure name only, the IN list code shown below -- can be modified to itemize the expected procedure names. Otherwise you must parse the -- procedure_name parameter and replace the simple code below with code that will evaluate -- all of the cases listed above. -- if upper(procedure_name) in ( 'MYAPP' ) then return TRUE; else return FALSE; end if; end wwv_flow_epg_include_mod_local; Now you can call procedure in url, example: http://<host>:<port>/<dad>/myapp and it will redirect to your application. You can also change Database Access Descriptor (DAD) default page be your procedure (default is apex what points to APEX builder login). Run this for example under SYS (change accordingly to your DAD name): BEGIN dbms_epg.set_dad_attribute('APEX', 'default-page', 'myapp'); END; Now when you point browser to http://<host>:<port>/<dad>/ it will redirect to your application instead of APEX builder login page. To list DADs and their paths you can use the following code: declare dads dbms_epg.varchar2_table; paths DBMS_EPG.VARCHAR2_TABLE; begin dbms_epg.get_dad_list ( dads); for i in 1..dads.count loop dbms_output.put_line('DAD: '||dads(i)); dbms_epg.get_all_dad_mappings ( dads(i), paths); for j in 1..paths.count loop dbms_output.put_line('path: '||paths(j)); end loop; end loop; end; Please check MacLochlainns Weblog post Oracle 11g XDB DADs as well.