Sunday, 17 April 2016


SMTP Mail Check to identify its triggering Mail or not :


There are 2 methods we can check SMTP.

1.Run the below procedure from SQL Prompt 

DECLARE
  v_From      VARCHAR2(80) := 'test@abc.com';
  v_Recipient VARCHAR2(80) := 'user@abc.com';
  v_Subject   VARCHAR2(80) := 'test subject';
  v_Mail_Host VARCHAR2(30) := '**.**.**.**';  --(SMTP MAIL SERVER IP)
  v_Mail_Conn utl_smtp.Connection;
  crlf        VARCHAR2(2)  := chr(13)||chr(10);
BEGIN
v_Mail_Conn := utl_smtp.Open_Connection(v_Mail_Host, 25);
utl_smtp.Helo(v_Mail_Conn, v_Mail_Host);
utl_smtp.Mail(v_Mail_Conn, v_From);
utl_smtp.Rcpt(v_Mail_Conn, v_Recipient);
utl_smtp.Data(v_Mail_Conn,
   'Date: '   || to_char(sysdate, 'Dy, DD Mon YYYY hh24:mi:ss') || crlf ||
   'From: '   || v_From || crlf ||
   'Subject: '|| v_Subject || crlf ||
   'To: '     || v_Recipient || crlf ||
   crlf ||
   'some message text'|| crlf ||      -- Message body
   'more message text'|| crlf
);
utl_smtp.Quit(v_mail_conn);
EXCEPTION
WHEN utl_smtp.Transient_Error OR utl_smtp.Permanent_Error then
   raise_application_error(-20000, 'Unable to send mail: '||sqlerrm);
END;


2. Below method using telnet

telnet **.**.**.***  **                               -- ( telnet IP port)
EHLO ***.**.7.16                    ( Server IP)
MAIL FROM: test@abc.com
RCPT TO: user@abc.com

DATA

Test mail.

No comments:

Post a Comment