title: Reset password in oracle apex
body: <p>So I am working on a custom authentication in oracle apex. In that, I want to add reset password function so I used the <code>Pl/SQL</code> function for reset password first it validates the user by user's email and then it sends the link to the email, in that it redirects to the users reset the password region there it shows this <a href="https://i.stack.imgur.com/rvGCB.png" rel="nofollow noreferrer">error</a>. For a long time this error is showing and I don't know how to fix this ...... this is the custom authentication code</p>
  <pre><code>    create or replace function  MY_AUTHENTICATION
      (p_username in VARCHAR2,
      p_password in VARCHAR2)
      return BOOLEAN
      is
          l_user USER_TABLE.user_name%type := upper(p_username);
          l_hash USER_TABLE.set_password%type;
          begin
              select user_name, set_password 
              into l_user, l_hash
              from USER_TABLE
              where user_name = p_username and set_password = p_password;
                  RETURN TRUE;
      EXCEPTION
          WHEN NO_DATA_FOUND
          THEN
              RETURN FALSE;                 
      end;
  </code></pre>
  <p>and this is my reset password code</p>
  <pre><code>    BEGIN
      
          APEX_CUSTOM_AUTH.SET_USER('COMIDA');
          APEX_CUSTOM_AUTH.LOGIN(
                                      P_UNAME =&gt; 'COMIDA',
                                      P_PASSWORD =&gt;'1234567890',
                                      P_SESSION_ID =&gt; :SESSION,
                                      P_APP_PAGE  =&gt; :APP_ID
                   );
      
      APEX_UTIL.RESET_PASSWORD(
                                      P_USER_NAME =&gt; UPPER(:P15_USER_NAME),
                                      P_OLD_PASSWORD =&gt; NULL,
                                      P_NEW_PASSWORD=&gt; :P15_PASSWORD,
                                      P_CHANGE_PASSWORD_ON_FIRST_USE =&gt; FALSE    
                          );
          
       
      APEX_AUTHENTICATION.LOGOUT(:SESSION,:APP_ID);
      END;
  </code></pre>