I want to ask, I made a procedure like this but why is the sender's name instead 'dbtools-apexext-noreply@ociapp-notifications.oracle.com
The sender's name should be cobapassword@gmail.com
and also want to ask how to prevent the link l_reset_link from being full like this, how to do it so that it is short and safe
DECLARE
l_reset_link VARCHAR2(2000);
BEGIN
l_reset_link := 'https://apex.oracle.com/pls/apex/r/belajar/coba-kirim-email/new-password?session=' || :APP_SESSION;
-- Send the email using APEX_MAIL.SEND
APEX_MAIL.SEND(
p_from => 'cobapassword@gmail.com',
p_to => :P3_EMAIL,
p_subj => 'New Password',
p_body => 'Please change your password using this link.',
p_body_html => 'Please change your password using this link. <a href="' || l_reset_link || '">Click Here</a>'
);
-- Push the email to the queue
apex_mail.push_queue;
END;