DECLARE
SendorAddress Varchar2(30) := '[email protected]';
ReceiverAddress varchar2(30) := '[email protected]';
EmailServer varchar2(30) := '10.10.1.20';
Port number := 25;
conn UTL_SMTP.CONNECTION;
crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 );
mesg VARCHAR2( 4000 );
mesg_body varchar2(4000);
BEGIN
conn:= utl_smtp.open_connection( EmailServer, Port );
utl_smtp.helo( conn, EmailServer );
utl_smtp.mail( conn, SendorAddress);
utl_smtp.rcpt( conn, ReceiverAddress );
mesg:=
'Content-Type: text/html; Charset=UTF8' || crlf ||
'Date:' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || crlf ||
'From:' || SendorAddress || crlf ||
'Subject: Sending Mail From Database' || crlf ||
'To: '|| ReceiverAddress || crlf ||
'Content-Type: text/html; Charset=UTF8' || crlf ||
'' || crlf ||
'謝謝!' || crlf;
utl_smtp.data( conn, mesg );
utl_smtp.quit( conn );
END;字顯示不出來,顯示問號,誰能幫忙解決下
SendorAddress Varchar2(30) := '[email protected]';
ReceiverAddress varchar2(30) := '[email protected]';
EmailServer varchar2(30) := '10.10.1.20';
Port number := 25;
conn UTL_SMTP.CONNECTION;
crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 );
mesg VARCHAR2( 4000 );
mesg_body varchar2(4000);
BEGIN
conn:= utl_smtp.open_connection( EmailServer, Port );
utl_smtp.helo( conn, EmailServer );
utl_smtp.mail( conn, SendorAddress);
utl_smtp.rcpt( conn, ReceiverAddress );
mesg:=
'Content-Type: text/html; Charset=UTF8' || crlf ||
'Date:' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || crlf ||
'From:' || SendorAddress || crlf ||
'Subject: Sending Mail From Database' || crlf ||
'To: '|| ReceiverAddress || crlf ||
'Content-Type: text/html; Charset=UTF8' || crlf ||
'' || crlf ||
'謝謝!' || crlf;
utl_smtp.data( conn, mesg );
utl_smtp.quit( conn );
END;字顯示不出來,顯示問號,誰能幫忙解決下
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货