Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SMTP error

Re: SMTP error

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: Tue, 26 Jul 2005 18:35:17 +0530
Message-ID: <a144e521050726060562af0d5e@mail.gmail.com>


Thanx for the quick response Tom but using the same server we are sending mails using JSP code but when I am trying to send mail via same server usiing oracle proc , its giving the error...

On 7/26/05, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.state.ny.us> wrote:
>
> Onkar,
>
> This means that the mail server is either not at that ip address or you
> cannot reach it
>
> Hope this helps.
>
> Tom
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Onkar N Tiwary
> *Sent:* Tuesday, July 26, 2005 7:49 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* SMTP error
>
>
> Hi all,
>
> I am trying to send mail using the following procedure. its just the
> simple one but i am getting the error however SMTP service is configured on
> the system and initplsj.sql and initjvm.sql(if not wrong) has been
> executed successfully. Need ur valuable comments.
>
> SQL> ed
> Wrote file afiedt.buf
>
> 1 DECLARE
> 2 v_connection UTL_SMTP.CONNECTION;
> 3 BEGIN
> 4 v_connection := UTL_SMTP.OPEN_CONNECTION('192.9.200.8<http://192.9.200.8/>
> ',25);
> 5 UTL_SMTP.HELO(v_connection,' 192.9.200.8 <http://192.9.200.8/>');
> 6 UTL_SMTP.MAIL(v_connection,'pasha_at_oneapps.com');
> 7 UTL_SMTP.RCPT(v_connection,'moqthiyar_at_yahoo.com');
> 8 UTL_SMTP.DATA(v_connection,'Sent From PL/SQL');
> 9 UTL_SMTP.QUIT(v_connection);
> 10* END;
> SQL> /
> DECLARE
> *
> ERROR at line 1:
> ORA-29278: SMTP transient error: 421 Service not available
> ORA-06512: at "SYS.UTL_SMTP", line 21
> ORA-06512: at " SYS.UTL_SMTP", line 97
> ORA-06512: at "SYS.UTL_SMTP", line 139
> ORA-06512: at line 4
>
> TIA
>
>
> --
> Thanks & Regards,
> T. Onkar Nath
> OneAPPS Enterprise Technology Pvt. Ltd.
> to_onkar_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>

-- 
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 26 2005 - 08:07:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US