I am writing a code which sends mail but it does not display any details over my mail
A blank mail is sent without any SUBJECT , BODY
Code :
CREATE OR REPLACE PROCEDURE MAIL_ME
(
v_frm in VARCHAR2,
v_msg in VARCHAR2,
v_smtp_hst in VARCHAR2,
v_smtp_prt in NUMBER DEFAULT 88
)
AS
m_conn UTL_SMTP.connection;
BEGIN
m_conn : = UTL_SMTP.open_connection(v_smtp_hst,v_smtp_prt);
UTL_SMTP.helo(m_conn,v_smtp_hst);
UTL_SMTP.mail(m_conn,v_frm);
UTL_SMTP.rcpt(m_conn,v_to);
UTL_SMTP.data(m_conn,v_msg || UTL_TCP.crlf || UTL_TCP.crlf);
UTL_SMTP.quit(m_conn);
END;
/
Calling :
BEGIN
MAIL_ME(
v_to => '[email protected]',
v_frm => '[email protected]'
v_msg => 'Hi Buddy!!!'
v_smtp_hst => 'PROTONMAIL.mtp.com'
);
END;
/
The mail is sent but no details shown over mail
Subject , Body is missing in mail sent