Thanks for the question regarding "About utl_smtp", version 8.1.7

妖狐艹你老母 2024-02-17 20:30 26阅读 0赞

***You Asked*** (Jump to Tom's latest followup)

Hi Tom,
    
    I created the procedure send_mail as in your book in the user System. 
    
    create or replace procedure send_mail
    ( p_sender in varchar2,
      p_recipient in varchar2,
      p_message in varchar2 )
    as
       l_mailhost varchar2(255) := '10.228.1.75' ;
       l_mail_conn utl_smtp.connection ;
    begin
       l_mail_conn := utl_smtp.open_connection(l_mailhost, 25) ;
       utl_smtp.helo(l_mail_conn, l_mailhost) ;
       utl_smtp.mail(l_mail_conn, p_sender) ;
       utl_smtp.rcpt(l_mail_conn, p_recipient ) ;
       utl_smtp.open_data(l_mail_conn) ;
       utl_smtp.write_data(l_mail_conn, p_message ) ;
       utl_smtp.close_data(l_mail_conn) ;
       utl_smtp.quit(l_mail_conn );
       dbms_output.put_line('Message send to the user successfully') ;
    end ;
    
    The procedure compiled without any error. I call the above procedure in the same 
    user as :
    
    begin
       send_mail('vrbala@visto.com',
            'vr_bala@yahoo.com',
            'This is the test message from oracle server' ) ;
    end ;
    
    I got the following error. What should i do to run this.
    
    ORA-20002: 554 Relay rejected for policy reasons.
    ORA-06512: at "SYS.UTL_SMTP", line 86
    ORA-06512: at "SYS.UTL_SMTP", line 223
    ORA-06512: at "SYSTEM.SEND_MAIL", line 12
    ORA-06512: at line 2
    
    Thanks,
    Bala

***and we said...***

Talk to your system and or network administrator.  This is 100% an smtp 
    configuration issue.  Your host (10.228.1.75) is not permitted to relay email 
    (to prevent spammers from using you as a jump off point).  You need to find the 
    valid smtp server within your organization.

<table> 
 <tbody> 
  <tr> 
   <td align="left"><img height="5" alt="" width="5" src="http://asktom.oracle.com/i/FFFFFFTL.gif"></td> 
   <td align="left">&nbsp;&nbsp;<font><strong>Reviews</strong></font></td> 
   <td align="right">&nbsp;&nbsp;&nbsp;</td> 
   <td align="right"><img height="5" alt="" width="5" src="http://asktom.oracle.com/i/FFFFFFTR.gif"></td> 
  </tr> 
  <tr> 
   <td colspan="4"> 
    <table> 
     <tbody> 
      <tr> 
       <td><a style="PADDING-RIGHT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#2119016501879" rel="nofollow"><font>GOTO a page to Bookmark Review</font></a> | <a style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGEBOTTOM" rel="nofollow"><font>Bottom</font></a> | <a style="PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGETOP" rel="nofollow"><font>Top</font></a></td> 
      </tr> 
     </tbody> 
    </table> <font><font><img alt="" src="http://asktom.oracle.com/i/stars5.gif"></font><strong>Thanks</strong>&nbsp;&nbsp;December 03, 2001 <br>Reviewer:&nbsp; <strong>Balasubramanian</strong> &nbsp;from Singapore </font><br> <pre>Thanks for immediate response. Also is there any way to
check validity of smtp server using oracle procedures. 
Because the administrator told this is the correct smpt
server.

Thanks,
Bala 
</pre> <br> 
    <table> 
     <tbody> 
      <tr> 
       <td align="left"><font><strong>Followup:<a rel="nofollow"></a></strong> </font></td> 
      </tr> 
      <tr> 
       <td> <pre>You did check the "validity" of the SMTP server -- you got the message back 
"relaying not allowed".  Your smtp server is simply NOT allowed to relay to 
hosts outside of its domain.  You can telnet right to the SMTP server to prove 
this to yourself.

The elements in bold are what you type in, please use your hostname of course.  
You should get the same output as you did from Oracle -- indicating simply that 
your server in visto.com is not allowed to relay to yahoo.com

$ <strong>telnet aria-dev 25</strong>
Trying 138.2.5.52...
Connected to aria-dev.us.oracle.com.
Escape character is '^]'.
220 aria-dev.us.oracle.com ESMTP Sendmail 8.9.3+Sun/8.9.1; Mon, 3 Dec 2001 
09:41:19 -0500 (EST)
<strong>helo aria-dev</strong>
250 aria-dev.us.oracle.com Hello aria-dev.us.oracle.com [138.2.5.52], pleased to 
meet you
<strong>mail from: tkyte@us.oracle.com</strong>
250 tkyte@us.oracle.com... Sender ok
<strong>rcpt to: Thomas.Kyte@oracle.com</strong>
250 Thomas.Kyte@oracle.com... Recipient ok
<strong>data</strong>
354 Enter mail, end with "." on a line by itself
<strong>this is a test
.</strong>
250 JAA17566 Message accepted for delivery
<strong>quit</strong>
221 aria-dev.us.oracle.com closing connection
Connection closed by foreign host.
 </pre> </td> 
      </tr> 
     </tbody> 
    </table> <br>&lt;script language="JavaScript1.1" type="text/javascript"&gt; document.getElementById("latestLink").style.display = "inline" &lt;/script&gt; 
    <table> 
     <tbody> 
      <tr> 
       <td><a style="PADDING-RIGHT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#2123569953414" rel="nofollow"><font>GOTO a page to Bookmark Review</font></a> | <a style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGEBOTTOM" rel="nofollow"><font>Bottom</font></a> | <a style="PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGETOP" rel="nofollow"><font>Top</font></a></td> 
      </tr> 
     </tbody> 
    </table> <font><font><img alt="" src="http://asktom.oracle.com/i/stars5.gif"></font><strong>Relaying Denied fixes</strong>&nbsp;&nbsp;December 03, 2001 <br>Reviewer:&nbsp; <strong>Andy Finkenstadt</strong> &nbsp;from Saint Charles MO </font><br> <pre>Tell your system adminstrator to allow the IP address for the database server 
initiating the email to relay, by adding the address to (typically) 
/etc/mail/relay-domains.

The relay prohibition comes most restrictively from that lack, or from not using 
an @locally.relayable.domain sender address if the administration is using 
FEATURE(relay_local_from).
 
</pre> <br> 
    <table> 
     <tbody> 
      <tr> 
       <td><a style="PADDING-RIGHT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#8918847936333" rel="nofollow"><font>GOTO a page to Bookmark Review</font></a> | <a style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGEBOTTOM" rel="nofollow"><font>Bottom</font></a> | <a style="PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGETOP" rel="nofollow"><font>Top</font></a></td> 
      </tr> 
     </tbody> 
    </table> <font><font><img alt="" src="http://asktom.oracle.com/i/stars3.gif"></font><strong>Ora-20001 :450 when executing procedure.</strong>&nbsp;&nbsp;March 31, 2003 <br>Reviewer:&nbsp; <strong>Vivek Sharma</strong> &nbsp;from Bombay, India </font><br> <pre>Hi Tom,

I am receiveing ora-20001 :450 error while executing a procedure. But no help is 
provided on Metalink for this. The content of my procedure is

PROCEDURE mail_job_check IS                      
    v_msg varchar2 (10000);    
    mailhost  varchar2(30) := '172.6.49.8' ;
    mail_conn utl_smtp.connection;        
crlf      varchar2(2):= CHR(13) || CHR(10);     
mesg      varchar2(20000);
c_mesg    varchar2(20000); 
a_mesg    varchar2(20000);
mail_id   user_info.ui_email%type;    
v_isin    varchar2(10000);    
c_isin    varchar2(10000);    
a_isin    varchar2(10000);     
v_from_dt date; 
       
    Cursor c1 is                  
    Select ui_user_cd          
    from   user_info           
    where  ui_active = 'N'                    
    and    to_char(ui_last_upd_dt,'dd-mm-yyyy')= to_char(sysdate,'dd-mm-yyyy'); 
BEGIN                                                           SELECT ui_email  
         
    INTO   mail_id             
    FROM   user_info           
    WHERE  ui_user_cd='SFG';           
    For x in c1 loop    
a_mesg:=a_mesg||crlf||x.ui_user_cd;    
end loop;            
    IF a_mesg IS NULL THEN                                                      
       a_mesg := 'No Users Deactivated Now '||to_char(sysdate,'dd-mm-yyyy');    
    END IF;             
    mail_conn := utl_smtp.open_connection(mailhost, 25);    
utl_smtp.helo(mail_conn, mailhost);    
utl_smtp.mail(mail_conn,'vivek.sharma@pidilite.com');    
utl_smtp.rcpt(mail_conn,mail_id);    
    utl_smtp.rcpt(mail_conn,'vivek.sharma@pidilite.com');
mesg:= 'Date: '||TO_CHAR(SYSDATE,'DD MON YYYY HH24:MI:SS' )|| crlf ||           
'From: CLMS Software Team '|| crlf ||           'Subject: Users deactivated on 
'||sysdate|| crlf||           a_mesg;         
    utl_smtp.data(mail_conn,mesg);   
    utl_smtp.quit(mail_conn);   
END;

When I execute this procedure, I get an error as

BEGIN clms.mail_job_check; END;

*
ERROR at line 1:
ORA-20001: 450 4.7.1 abhi_s@@pidilite.com... Relaying temporarily
denied. Cannot resolve PTR record for 10.16.0.75
ORA-06512: at "SYS.UTL_SMTP", line 83
ORA-06512: at "SYS.UTL_SMTP", line 223
ORA-06512: at "CLMS.MAIL_JOB_CHECK", line 34
ORA-06512: at line 1

Please suggest a workaround.

Thanks in advance. 
</pre> <br> 
    <table> 
     <tbody> 
      <tr> 
       <td align="left"><font><strong>Followup:<a rel="nofollow"></a></strong> </font></td> 
      </tr> 
      <tr> 
       <td> <pre>workaround:  read the error message.

You are getting apparently a 450 error from your SMTP server (the ora-20001 is 
utl_smtp's way to saying "error encountered -- here is more information"

If you just:

[tkyte@tkyte-pc Desktop]$<strong> telnet 172.6.49.8 25</strong>
Trying 172.6.49.8...
Connected to xxxx.
Escape character is '^]'.
220 aria.us.oracle.com ESMTP Sendmail 8.10.2+Sun/8.10.2; Mon, 31 Mar 2003 
08:35:55 -0500 (EST)
<strong>HELO &lt;hostname -- whatever the hostname of 172.6.49.8 is&gt;</strong>
250 aria.us.oracle.com Hello tkyte-pc.us.oracle.com [138.1.120.255], pleased to 
meet you
<strong>MAIL FROM: vivek.sharma@pidilite.com</strong>
250 2.1.0 vivek.sharma@pidilite.com... Sender ok
<strong>RCPT TO: vivek.sharma@pidilite.com</strong>
250 2.1.5 vivek.sharma@pidilite.com... Recipient ok
<strong>DATA</strong>
354 Enter mail, end with "." on a line by itself
<strong>hello tom
.</strong>
250 2.0.0 h2VDb7229862 Message accepted for delivery
<strong>QUIT</strong>
221 2.0.0 aria.us.oracle.com closing connection
Connection closed by foreign host.
[tkyte@tkyte-pc Desktop]$

and you just enter the stuff in <strong>BOLD</strong>, you'll reproduce the same exact error. 
 This is a SMTP configuration issue -- you need to talk to your email guys. </pre> </td> 
      </tr> 
     </tbody> 
    </table> <br>&lt;script language="JavaScript1.1" type="text/javascript"&gt; document.getElementById("latestLink").style.display = "inline" &lt;/script&gt; 
    <table> 
     <tbody> 
      <tr> 
       <td><a style="PADDING-RIGHT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#9206460145191" rel="nofollow"><font>GOTO a page to Bookmark Review</font></a> | <a style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGEBOTTOM" rel="nofollow"><font>Bottom</font></a> | <a style="PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGETOP" rel="nofollow"><font>Top</font></a></td> 
      </tr> 
     </tbody> 
    </table> <font><font><img alt="" src="http://asktom.oracle.com/i/stars4.gif"></font><strong>utl_smtp strangeness 9.2</strong>&nbsp;&nbsp;April 14, 2003 <br>Reviewer:&nbsp; <strong>Ray</strong> &nbsp;from Ottawa,On,ca </font><br> <pre>declare
mailhost  varchar2(30) := '999.11.2.99' ;
mail_conn utl_smtp.connection;        
mesg      varchar2(4000);
begin
mail_conn := utl_smtp.open_connection(mailhost, 25);    
utl_smtp.helo(mail_conn, mailhost);

utl_smtp.mail(mail_conn,'a_b@aaa-bbb.xx.yy');
   
utl_smtp.rcpt(mail_conn,'a_b@aaa-bbb.xx.yy');    
mesg:= 'text';         
utl_smtp.data(mail_conn,mesg);   
utl_smtp.quit(mail_conn);   
END;

ORA-29279: SMTP permanent error: 501 strangeness between : and &lt;
ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 98
ORA-06512: at "SYS.UTL_SMTP", line 221
ORA-06512: at line 8

this error occurs at the .mail call

What is it trying to tell me with between : and &lt;

When I telnet this IP it responds initially but that's it

The mail server is notes/domin

any help is appreciated.
 
</pre> <br> 
    <table> 
     <tbody> 
      <tr> 
       <td align="left"><font><strong>Followup:<a rel="nofollow"></a></strong> </font></td> 
      </tr> 
      <tr> 
       <td> <pre>Well, thats not a database error -- that is the SMTP server being finicky.

RFC 821 states that all envelope information should be enclosed in angle 
brackets.

try putting &lt;&gt; about your email addresses. </pre> </td> 
      </tr> 
     </tbody> 
    </table> <br>&lt;script language="JavaScript1.1" type="text/javascript"&gt; document.getElementById("latestLink").style.display = "inline" &lt;/script&gt; 
    <table> 
     <tbody> 
      <tr> 
       <td><a style="PADDING-RIGHT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#9283881767471" rel="nofollow"><font>GOTO a page to Bookmark Review</font></a> | <a style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGEBOTTOM" rel="nofollow"><font>Bottom</font></a> | <a style="PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGETOP" rel="nofollow"><font>Top</font></a></td> 
      </tr> 
     </tbody> 
    </table> <font><font><img alt="" src="http://asktom.oracle.com/i/stars5.gif"></font><strong>smtp</strong>&nbsp;&nbsp;April 17, 2003 <br>Reviewer:&nbsp; <strong>Ray</strong> &nbsp;from Ottawa,on,ca </font><br> <pre>yup that did it thanks 
</pre> <br> 
    <table> 
     <tbody> 
      <tr> 
       <td><a style="PADDING-RIGHT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#10732991127696" rel="nofollow"><font>GOTO a page to Bookmark Review</font></a> | <a style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGEBOTTOM" rel="nofollow"><font>Bottom</font></a> | <a style="PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGETOP" rel="nofollow"><font>Top</font></a></td> 
      </tr> 
     </tbody> 
    </table> <font><font><img alt="" src="http://asktom.oracle.com/i/stars4.gif"><strong></strong></font>&nbsp;&nbsp;June 28, 2003 <br>Reviewer:&nbsp; <strong>j.</strong> </font><br> <pre>hi tom, everything works fine so far.

now I wonder if there is any way to check whether given email addresses were 
valid.

can the database get notified if mail delivery fails? 
</pre> <br> 
    <table> 
     <tbody> 
      <tr> 
       <td align="left"><font><strong>Followup:<a rel="nofollow"></a></strong> </font></td> 
      </tr> 
      <tr> 
       <td> <pre>the email will bounce back and you can use the other parts of the javamail api 
to "read" mail as easily as "send mail"

so, instead of using utl_smtp, you can load up the java mail api and use it to 
do lots more. </pre> </td> 
      </tr> 
     </tbody> 
    </table> <br>&lt;script language="JavaScript1.1" type="text/javascript"&gt; document.getElementById("latestLink").style.display = "inline" &lt;/script&gt; 
    <table> 
     <tbody> 
      <tr> 
       <td><a style="PADDING-RIGHT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#19783439560766" rel="nofollow"><font>GOTO a page to Bookmark Review</font></a> | <a style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGEBOTTOM" rel="nofollow"><font>Bottom</font></a> | <a style="PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGETOP" rel="nofollow"><font>Top</font></a></td> 
      </tr> 
     </tbody> 
    </table> <font><font><img alt="" src="http://asktom.oracle.com/i/stars4.gif"></font><strong>How can we provide username and password for smtp auth</strong>&nbsp;&nbsp;June 15, 2004 <br>Reviewer:&nbsp; <strong>Monish</strong> &nbsp;from CO, US </font><br> <pre>Hi Tom,

We are using SMTP Authentication. Is there a way I could provide username and 
password to the smtp server via pl/sql.

SQL&gt; execute send_mail('support@xyz.com','abc@jfk.com','this is a test');
BEGIN send_mail('support@xyz.com','abc@jfk.com','this is a test'); END;

*
ERROR at line 1:
ORA-29279: SMTP permanent error: 530 Authentication Required
ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 98
ORA-06512: at "SYS.UTL_SMTP", line 240
ORA-06512: at "SCOTT.SEND_MAIL", line 11
ORA-06512: at line 1

Thanks 
</pre> <br> 
    <table> 
     <tbody> 
      <tr> 
       <td align="left"><font><strong>Followup:<a rel="nofollow"></a></strong> </font></td> 
      </tr> 
      <tr> 
       <td> <pre>you can write directly to the SMTP server and do the authorization, yes.

just telnet to your SMTP server (telnet hostname 25) and type HELP

&gt; telnet aria 25
Trying 138.2.5.51...
Connected to aria.
Escape character is '^]'.
220 aria-lnx.us.oracle.com ESMTP Sendmail 8.11.6/8.11.6; Wed, 16 Jun 2004 
12:02:18 -0400
HELP
214-2.0.0 This is sendmail version 8.11.6
214-2.0.0 Topics:
214-2.0.0       HELO    EHLO    MAIL    RCPT    DATA
214-2.0.0       RSET    NOOP    QUIT    HELP    VRFY
214-2.0.0       EXPN    VERB    ETRN    DSN     AUTH
214-2.0.0       STARTTLS
214-2.0.0 For more info use "HELP &lt;topic&gt;".
214-2.0.0 To report bugs in the implementation send email to
214-2.0.0       sendmail-bugs@sendmail.org.
214-2.0.0 For local information send email to Postmaster at your site.
214 2.0.0 End of HELP info

You'll see a list of commands it supports.  from there, you'll have to figure 
out the protocol your server is using to authenticate (should be able to google 
that up, some rfc somewhere)....

then you can use utl_smtp to write that information to the SMTP server. </pre> </td> 
      </tr> 
     </tbody> 
    </table> <br>&lt;script language="JavaScript1.1" type="text/javascript"&gt; document.getElementById("latestLink").style.display = "inline" &lt;/script&gt; 
    <table> 
     <tbody> 
      <tr> 
       <td><a style="PADDING-RIGHT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#32052813777561" rel="nofollow"><font>GOTO a page to Bookmark Review</font></a> | <a style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGEBOTTOM" rel="nofollow"><font>Bottom</font></a> | <a style="PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGETOP" rel="nofollow"><font>Top</font></a></td> 
      </tr> 
     </tbody> 
    </table> <font><font><img alt="" src="http://asktom.oracle.com/i/stars5.gif"></font><strong>it is very handy </strong>&nbsp;&nbsp;January 19, 2005 <br>Reviewer:&nbsp; <strong>Mehmood</strong> &nbsp;from Karachi, Pakistan </font><br> <pre>Dear Tom:

It is very handy to get emails from Oralce server. I have used the same 
procedure which you have given, I do get the emails from Oracle server having 
used the UTL_SMTP, but unfortunately I dont get any message in those emails. 
Your response will be highly appreicated. 
</pre> <br> 
    <table> 
     <tbody> 
      <tr> 
       <td align="left"><font><strong>Followup:<a rel="nofollow"></a></strong> </font></td> 
      </tr> 
      <tr> 
       <td> <pre>it has always worked for me.

ctl-f on this page for telnet.  do it by hand.  take the database out of the 
loop. All we are doing is exactly what you can do in telnet.  </pre> </td> 
      </tr> 
     </tbody> 
    </table> <br>&lt;script language="JavaScript1.1" type="text/javascript"&gt; document.getElementById("latestLink").style.display = "inline" &lt;/script&gt; 
    <table> 
     <tbody> 
      <tr> 
       <td><a style="PADDING-RIGHT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#39183729595369" rel="nofollow"><font>GOTO a page to Bookmark Review</font></a> | <a style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGEBOTTOM" rel="nofollow"><font>Bottom</font></a> | <a style="PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGETOP" rel="nofollow"><font>Top</font></a></td> 
      </tr> 
     </tbody> 
    </table> <font><font><img alt="" src="http://asktom.oracle.com/i/stars4.gif"></font><strong>utl_smtp.data</strong>&nbsp;&nbsp;April 20, 2005 <br>Reviewer:&nbsp; <strong>Ratnamachary</strong> &nbsp;from IND </font><br> <pre>Tom,
I've problem in sending text more than 2000 charectors using utl.smtp.data 
function.
Is there any limitation for this?
I'm getting Numeric or Value error.
The text which I want to send I'm building in PL/SQL procedure and passing as 
input parameter for sendmail procedure.
I'm using Oracle version 8.1.7.

Please advise.

Thanks
-Chary 
</pre> <br> 
    <table> 
     <tbody> 
      <tr> 
       <td align="left"><font><strong>Followup:<a rel="nofollow"></a></strong> </font></td> 
      </tr> 
      <tr> 
       <td> <pre>give example. </pre> </td> 
      </tr> 
     </tbody> 
    </table> <br>&lt;script language="JavaScript1.1" type="text/javascript"&gt; document.getElementById("latestLink").style.display = "inline" &lt;/script&gt; 
    <table> 
     <tbody> 
      <tr> 
       <td><a style="PADDING-RIGHT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#48141040867982" rel="nofollow"><font>GOTO a page to Bookmark Review</font></a> | <a style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGEBOTTOM" rel="nofollow"><font>Bottom</font></a> | <a style="PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2118740358226#PAGETOP" rel="nofollow"><font>Top</font></a></td> 
      </tr> 
     </tbody> 
    </table> <font><font><img alt="" src="http://asktom.oracle.com/i/stars3.gif"></font><strong>Error 530 - Authentication required</strong>&nbsp;&nbsp;September 20, 2005 <br>Reviewer:&nbsp; <strong>Manju P</strong> &nbsp;from IND </font><br> <pre>Hi,

I am trying to send a mail to myself. I am getting the same error. tried almost 
everything mentioned here. 
ERROR at line 1:
ORA-20002: 530 Authentication required ORA-06512: at "SYS.UTL_SMTP", line 86 
ORA-06512: at "SYS.UTL_SMTP", line 204 
ORA-06512: at "CM_UAT.SEND_MAIL", line 10 ORA-06512: at line 2

sometimes i am getting error 421 - Service not available error.

latest is plsql statement executed successfully. BUT I STILL HAVEN'T RECEIVED 
THE MAIL 
</pre> <br> 
    <table> 
     <tbody> 
      <tr> 
       <td align="left"><font><strong>Followup:<a rel="nofollow"></a></strong> </font></td> 
      </tr> 
      <tr> 
       <td> <pre>that is saying you need to supply a username and password to use your SMTP 
server - you need to either

ask you admins for an smtp server that doesn't need that (likely you don't have 
one if they use one with authentication)

read a bit about the smtp protocol and see how to send the required 
authentication tokens. </pre> </td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
 </tbody> 
</table>