| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: HOW TO: Mail containing multilingual text from database
Prem,
I copied the code as is and executed it after updating mail server, recipient id and msg variable.
No luck. Still the same.
Data column value retrieved from db:
And following is what the mail reported:
Quality ???????? <----- question mark coming instead of original text.
Thnx
Suneet
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Prem Khanna J
Sent: March 12, 2004 1:57 PM
To: oracle-l_at_freelists.org
Cc: suneet.madhok_at_patni.com
Subject: RE: HOW TO: Mail containing multilingual text from database
Hi Suneet ,
use the script below . it works for me in 9iR2. Note this line --> UTL_SMTP.WRITE_RAW_DATA
Regards,
Prem.
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);
 |
 |