Tag: pl/sql

A quick post on how to send an email with PL/SQL. There’s a LOT of documentation available at the following link: http://www.orafaq.com/wiki/Send_mail_from_PL/SQL PROCEDURE EMAIL_ERROR_REPORT IS /* Create vars */ v_From VARCHAR2 (80) := ‘test@test.com’; v_Recipient VARCHAR2 (80) := ‘me@me.com’;–REPORT_RECEIVER; v_Subject VARCHAR2 (80) := ‘test subject’; v_Mail_Host VARCHAR2 (30) := ‘smtp.test.com’; v_Mail_Conn UTL_SMTP.Connection; crlf VARCHAR2 (2)…