1. UTL_SMTP

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 Hyperlink' || crlf ||
 
'To: Mrs Receiver <Receiver@erpschools.com>' || crlf ||
 
'<a href="http://www.erpschools.com" target="new" www.erpschools.com</a>' || crlf || crlf ;
 
utl_smtp.data(mail_conn, 'MIME-Version: 1.0' ||CHR(13)||CHR(10)||'Content-type: text/html' || CHR(13)||CHR(10)||message_1);
 
utl_smtp.quit (mail_conn);
 
END;

2. UTL_MAIL: This is the new package introduced in 10g. even though this uses the UTL_SMTP in the background the advantage with this script is we can change the mail server and ports in the configuration file with out changing the code.

I will update this very soon.

admin

  One Response to “Send e mail through PL SQL code”

  1. Hey…

    how to send email to multiple receipants?? rather than single 1.

    Thanks,

 Leave a Reply

*

*


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

© 2011 erpSchools Suffusion theme by Sayontan Sinha