Re: ORA-30678 When sending email.

From: Noel <tomekb_at_s_o_f_t_m_a_n.pl>
Date: Wed, 05 Jan 2005 10:10:03 +0100
Message-ID: <crgbar$p24$1@nemesis.news.tpi.pl>

Dnia 1/5/2005 9:40 AM, Użytkownik csharpgeek napisał:

> When using the code above with the correct fields i get this error
> which is rather odd as the data is correct
>
> ORA-29279: SMTP permanent error: 503 No valid recipients specified
> ORA-06512: at "SYS.UTL_SMTP", line 17
> ORA-06512: at "SYS.UTL_SMTP", line 98
> ORA-06512: at "SYS.UTL_SMTP", line 271
> ORA-06512: at "SYS.UTL_SMTP", line 247
> ORA-06512: at line 11
>

Lets bring your code:

 > v_connection := UTL_SMTP.OPEN_CONNECTION('mail.newreg.com',25);
                                           ^^^^^^^^^^^^^^^
 > v_reply := UTL_SMTP.HELO(v_connection,'mail.xxxxxxxx.com');
                                        ^^^^^^^^^^^^^^^^^^

Those values should match.

 > v_reply := UTL_SMTP.DATA(v_connection,'Sent From PL/SQL');

Shouldn't it be replaced with:

  UTL_SMTP.OPEN_DATA(v_reply);
  UTL_SMTP.WRITE_DATA(v_reply, 'Sent From PL/SQL');
  UTL_SMTP.CLOSE_DATA(v_reply);




 > v_reply := UTL_SMTP.MAIL(v_connection,c_at_xxxxxxxx.com');
                                        ^^^
 > v_reply := UTL_SMTP.RCPT(v_connection,c_at_xxxxxxxx.com');
                                        ^^^

There is ' missing...

-- 
Noel

Received on Wed Jan 05 2005 - 03:10:03 CST