2 Replies Latest reply on Jan 12, 2017 7:02 PM by Guil Sa-Oracle

    Configuring a custom login redirect URL

    Guil Sa-Oracle

      I’m on APEX  5.0.4.00.12 and SQLPlus 11.2.0.3.0 and have built a custom authentication leveraging the Login Page template, which calls apex_authentication.login().

       

      How can I configure the redirect during the login form submit process below? Currently it redirects to a page I don’t want but I can't even find the code/GUI configuration for that.

       

      Login process:

       

      apex_authentication.login(

          p_username => :P_EMAIL,

          p_password => :P_PASSWORD

      );

       

      Below is what I’ve tried, but doesn’t work. It returns ORA-06550: line 1, column 58: PLS-00306: wrong number or types of arguments in call to 'LOGIN' ORA-06550: line 1, column 58: PL/SQL: Statement ignored.

       

      apex_authentication.login(

          p_username => :P_EMAIL,

          p_password => :P_PASSWORD,

          P_SESSION_ID  => v('APP_SESSION'),

          P_FLOW_PAGE   => :APP_ID||':16'

      );

       

      Thank you in advance.

       

      PS - According to the doc's LOGIN procedure [1], “If result=true: set redirect url to deep link." I wonder if deep link has anything to do with this.

       

      [1]. https://docs.oracle.com/database/121/AEAPI/apex_authentication.htm#AEAPI29157