RE: HOW TO: Mail containing multilingual text from database
- From: "Suneet" <suneet.madhok@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Mar 2004 15:21:35 +0530
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:
******************************
Quality 原材料リジェクト
And following is what the mail reported:
*******************************
admin@xxxxxxxx
suneet.madhok@xxxxxxxxx
Subject: DBA Alert
MIME-version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Quality ???????? <----- question mark coming instead of original text.
Thnx
Suneet
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Prem Khanna J
Sent: March 12, 2004 1:57 PM
To: oracle-l@xxxxxxxxxxxxx
Cc: suneet.madhok@xxxxxxxxx
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.
------------------------- 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@xxxxxxxx>';
recipient varchar2(100) := 'To: "You" <dba@xxxxxxxx>';
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
