Wants to Send Email Msg With Multiple Lines
735688May 26 2011 — edited Jun 8 2011Friends,
I want to send multiple lines message/data in my oracle pl/sql email message. Please see below data format which i want to send in my email message.
7369 SMITH
7499 ALLEN
7521 WARD
7566 JONES
7654 MARTIN
7698 BLAKE
7782 CLARK
7788 SCOTT
DECLARE
mailhost VARCHAR2 (30) := 'my_smtp';
mail_conn utl_smtp.connection;
crlf VARCHAR2(2) := CHR (13) || CHR (10);
message_1 LONG;
v_email varchar2(16000);
v_sub varchar2(10000);
BEGIN
mail_conn := utl_smtp.open_connection (mailhost, 25);
utl_smtp.helo (mail_conn, mailhost);
utl_smtp.mail (mail_conn, 'test@mobilink.net');
utl_smtp.rcpt (mail_conn, 'test@mobilink.net');
FOR I IN (SELECT EMPNO,ENAME FROM SCOTT.EMP) LOOP
message_1 := message_1||RPAD(I.EMPNO,7,' ')||RPAD(I.ENAME,30,' ')||CHR(13);
END LOOP;
dbms_output.put_line(message_1);
v_sub := 'Subject: '||'Hello';
message_1 := 'From: Irfan Ahmad < test@mobilink.net >' ||crlf||v_sub||crlf||crlf||crlf||message_1;
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;
Regards,
Irfan Ahmad