Utl_smtp

[praveenmeka]

I've written a small PL/SQL code to send mails using UTL_SMTP.
while testing the connection it gives me an error. I've tried giving Mail server name, IP Address.. but still it gives the error, And also I've tried giving localhost, PL/SQL block was successfull but there's no mail..Is there anything from System Administrator side who can do something for me??When I tried giving ping 10.150.49.99(SMTP server IP)it is not connecting..it says Request timed out..Does system admin need to give access to anything??


DECLARE
v_connection UTL_SMTP.CONNECTION;
v_reply UTL_SMTP.REPLY;
BEGIN
v_connection := UTL_SMTP.OPEN_CONNECTION('10.150.49.99',25);
v_reply := UTL_SMTP.HELO(v_connection,'10.153.50.99');
v_reply := UTL_SMTP.MAIL(v_connection,'praveenkumar.meka@wipro.com');
v_reply := UTL_SMTP.RCPT(v_connection,'praveenkumar.meka@wipro.com');
v_reply := UTL_SMTP.DATA(v_connection,'Sent From PL/SQL');
v_reply := UTL_SMTP.QUIT(v_connection);
END;
SQL> /
DECLARE
*
ERROR at line 1:
ORA-20001: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 83
ORA-06512: at "SYS.UTL_SMTP", line 121
ORA-06512: at line 5

[DaPi]

Originally posted by praveenmeka
When I tried giving ping 10.150.49.99(SMTP server IP)it is not connecting..it says Request timed out..

This is the first thing to get working. You need to get some help from your network guy - there are SO many things that could be wrong: bad IP address, machine down, bad routing table on your sever (or elsewhere), subnets not connected, fire-wall . . .