UTL_SMTP mail send with No subject , body

191 views Asked by At

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 
0

There are 0 answers