Guest User

Untitled

a guest
Feb 18th, 2019
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. CREATE OR REPLACE PROCEDURE send_mail_xyz
  2. (p_to IN VARCHAR2,
  3. p_from IN VARCHAR2,
  4. p_message IN VARCHAR2,
  5. p_smtp_host IN VARCHAR2,
  6. p_smtp_port IN NUMBER DEFAULT 25)
  7. AS
  8. l_mail_conn UTL_SMTP.connection;
  9. BEGIN
  10. dbms_output.put_line('9.1'||sysdate);
  11. l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);
  12. dbms_output.put_line('9.2'||sysdate);
  13. UTL_SMTP.helo(l_mail_conn, p_smtp_host);
  14. UTL_SMTP.mail(l_mail_conn, p_from);
  15. UTL_SMTP.rcpt(l_mail_conn, p_to);
  16. UTL_SMTP.data(l_mail_conn, p_message || UTL_TCP.crlf || UTL_TCP.crlf);
  17. UTL_SMTP.quit(l_mail_conn);
  18. END;
  19. /
  20.  
  21.  
  22.  
  23. While sending mail through send_mail_xyz
  24.  
  25.  
  26. and output is
  27.  
  28. anonymous block completed
  29.  
  30. 9.118-02-2019 12:11:25
  31.  
  32. 9.218-02-2019 12:31:25
Add Comment
Please, Sign In to add comment