Tag: UTL_SMTP

  • Send e mail through PL SQL code (UTL_SMTP, UTL_MAIL)

    utl_smtp example: CREATE OR REPLACE PROCEDURE erpschools_send_email IS mailhost varchar2 (30) := ‘smtp.erpschools.com’; crlf varchar2(2)Â := CHR (13) || CHR (10); v_email varchar2(16000); message_1 LONG; mail_conn utl_smtp.connection; BEGIN mail_conn := utl_smtp.open_connection (mailhost, 25); utl_smtp.helo (mail_conn, mailhost); utl_smtp.mail (mail_conn, ‘sender@erpschools.com’); utl_smtp.rcpt (mail_conn, ‘receiver@erpschools.com’); message_1 := ‘From: Mr Sender < sender@erpschools.com >‘ || crlf || ‘Subject: Testing…