create or replace procedure ProcSendEmail(txt varchar2)
IS
--sender's email address
SendorAddress Varchar2(30) := 'xxx@xxx.com';   
--receiver 's email address
ReceiverAddress varchar2(30) := 'xxx@xxx.com';
--mail server's name or ip address
EmailServer varchar2(30) := '10.10.1.168';
Port number := 25;

conn UTL_SMTP.CONNECTION;
crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 );
contentmsg VARCHAR2( 60 ) := 'hello';
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/plain; Charset=GB2312' || 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/plain; Charset=GB2312' || crlf ||
'' || crlf || txt || crlf ;

utl_smtp.data( conn, mesg );
utl_smtp.quit( conn );

END;

Â¥Ö÷µÄƽ̨£¿

ORA-20001: 421 Service not available
ORA-06512: ÔÚ"SYS.UTL_SMTP", line 83
ORA-06512: ÔÚ"SYS.UTL_SMTP", line 121
ORA-06512: ÔÚ"SYS.PROCSENDEMAIL", line 18
ORA-06512: ÔÚline 7
ÎÒµÄÔõô²»ÄÜÔËÐа¡.Äܲ»ÄÜ˵˵Ϊʲô°¡

ÎÒÊÔ¹ýÁË£¬¿ÉÒÔ·¢ËÍ£¡£¡£¡

Â¥ÉÏ,ÎÒ×ÔÒѵÄÓÊÏäÄѵÀ²»ÓõǼÂð?
ÎÒÀûÓÃsinaµÄsmtp.sina.com.cn
³öÏÖ
ORA-20002: 553 ________________________________________________________________________________     SMTP µÇ¼³ö´í¡£ÐÂÀËÓʼþϵͳÔö¼ÓÁË SMTP ·þÎñÈÏÖ¤£¬´Ó 2001 Äê 2 Ô 28 ÈÕÆð£¬Ö»ÓÐÐÂÀË»áÔ±²ÅÄÜÏíÊÜ´ËÏî·þÎñ¡£Çë·ÃÎÊÐÂÀËÓʼþÍøÕ¾²é¿´ÓйØ֪ͨ¼°ÉèÖ÷½·¨£¬ÍøÖ·ÊÇ£ºhttp://mail.sina.com.cn/smtp.html - authentication required, see http://mail.sina.com.cn/smtp.html for setup details.     ____________________________________________________________________________________________________
ORA-06512: ÔÚ"SYS.UTL_SMTP", line 86
ORA-06512: ÔÚ"SYS.UTL_SMTP", line 204
ORA-06512: ÔÚ"SYS.PROCSENDEMAIL", line 20
ORA-06512: ÔÚline 7

²»ÄÜ·¢ËÍÖÐÎÄ£¬Ï£ÍûÄܸĽø
SQL> exec ProcSendEmail("±ðÈËÁ÷µÄÀὫÊÇÎҵĽÌѵ";
BEGIN ProcSendEmail("±ðÈËÁ÷µÄÀὫÊÇÎҵĽÌѵ"; END;

                    *
ERROR at line 1:
ORA-06550: line 1, column 21:
PLS-00201: identifier '1pHKAw5D@a=+JGNR5D=LQ5' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

±ØÐëÓÐJserverÕâ¸ö²¿¼þ°¡

¹ÖÁË,ÎÒ·¢ÁËn´Î,ÓÐÒ»´Î³É¹¦,µ«²»ÖªÊÇÄÄÒ»´Î.ÓôÃÆÖÐ....

ÇëÎÊ
EmailServer ----------------- '10.10.1.168';          ÊÇÖ¸¶¨±¾µ¥Î»µÄMAIL SERVERÂð£¿
Port number ------------------- 25;   ÊÇÔõôȷ¶¨µÄ

Ã÷°×À­EmailServer ÒªÇóÊÇÓÐЧµÄMAIL·þÎñÆ÷·ñÔò³öÏÖyangqingdelphi
Óöµ½µÄ´íÎó
лл
nattyneat£¡