RE: HOW TO: Mail containing multilingual text from database

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Fri, 12 Mar 2004 17:27:20 +0900
Message-ID: <000701c4080b$d651bd00$dd00a8c0@prem>

Hi Suneet ,

use the script below . it works for me in 9iR2. Note this line --> UTL_SMTP.WRITE_RAW_DATA

Regards,
Prem.

• 8< ------------------------- 8<
• 8< ------------------------- 8< create or replace procedure send_email as

mailhost varchar2(100) := '111.222.333.444'; mail_conn utl_smtp.connection;
dates varchar2(100) := 'Date: ' || to_char( sysdate, 'dd-Mon-yyyy HH24:MI' );
sender varchar2(100) := 'From: "DBA" <admin_at_test.com>'; recipient varchar2(100) := 'To: "You" <dba_at_test.com>'; subj varchar2(100) := 'Subject: DBA Alert '; mimev varchar2(100) := 'MIME-version: 1.0'; ctype varchar2(100) := 'Content-Type: text/plain; charset=utf-8'; cenc varchar2(100) := 'Content-Transfer-Encoding: 8bit'; msg varchar2(2000) ;

begin

        msg := ' your multilingual email body here ' ;         

	mail_conn :=utl_smtp.open_connection(mailhost,25);
	utl_smtp.helo(mail_conn,mailhost);
	utl_smtp.mail(mail_conn,sender);
	utl_smtp.rcpt(mail_conn,recipient);
	utl_smtp.open_data(mail_conn);
	utl_smtp.write_data(mail_conn,dates || utl_tcp.CRLF);
	utl_smtp.write_data(mail_conn,sender || utl_tcp.CRLF);
	utl_smtp.write_data(mail_conn,recipient || utl_tcp.CRLF);
	utl_smtp.write_data(mail_conn,subj || utl_tcp.CRLF);
	utl_smtp.write_data(mail_conn,mimev || utl_tcp.CRLF);
	utl_smtp.write_data(mail_conn,ctype || utl_tcp.CRLF);
	utl_smtp.write_data(mail_conn,cenc || utl_tcp.CRLF);
	utl_smtp.write_raw_data(mail_conn,
utl_raw.cast_to_raw(utl_tcp.CRLF|| msg || utl_tcp.CRLF));
	utl_smtp.close_data(mail_conn);
	utl_smtp.quit(mail_conn); 

end;

• 8< ------------------------- 8<
• 8< ------------------------- 8<

  ---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Mar 12 2004 - 02:23:02 CST