How to log in the Oracle APEX Application with Authentication 'Custom' type

I will emphasize a few points in the application:
1)Account Register
2)Sign in
3)Forgot Password

/*Table and Column*/
Table : MTL_USER:
Column: User_id(pk)
email
password,
verification_code
role_id

/*Function or Procedure*/
/*log in the application. if true then pass, otherwise false*/
function custom_authenticate
(
p_username in varchar2,
p_password in varchar2
)
return boolean;

/*register the account*/
procedure create_account(
p_email in varchar2,
p_password in varchar2);

/*Check the verification code*/
function verify_reset_password(
p_id in number,
p_verification_code in varchar2)
return number;

/*request the mail and send the email*/
procedure request_reset_password(
p_email in varchar2) ;

/*send the emai*/
procedure mail_reset_password(
p_email in varchar2,
p_url in varchar2) ;

/*reset password*/
procedure reset_password(
p_id in number,
p_password in varchar2) ;

/*check if the user is administrator*/
function authz_administrator(
p_username in varchar2)
return boolean ;

/*check if the user existed*/
function authz_user(
p_username in varchar2)
return boolean ;

[weililiu]

If you'd like to get the code, you can go to the GitHub and get source
Thanks🙂

[ilyesbenmalti]

I have a problem where a button with behavior set to redirect to a page in this app doesn't redirect me to a page, can you tell me how to fix this isssue please

[ahmedashraf]

after i reset from the gmail
the login page open> after i sign in again > it crashes
the error i have provided in the prev comment

please help me

[JoachimForster-jygp]

tank you for the video !, can you please share the code ? package ? 🙏

[ahmedashraf]

is this vedio need any service need money ?

[sjn]

Hi, good video and knowledge. here I have one question. in mail ur sending url to change password is same for all. if any one can get that url can change and hack the application. So what's the security.

[bhavinadhvaryu]

Really nice blog...thank you for sharing