Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

421 Too many concurrent SMTP connections; please try again later.

639708May 27 2008 — edited May 27 2008
Hi,
At first I send an email, it works fine. After i try again but this time, i get "421 Too many concurrent SMTP connections; please try again later". What do i have to do? Thanks

create or replace PROCEDURE SEND_MAIL
(name_in IN Varchar, surname_in IN Varchar, email_in IN Varchar)
IS
conn utl_smtp.connection;

BEGIN

conn := utl_smtp.open_connection ( 'mail.ppp.com', 25 ); -- SMTP database host and on port 25
utl_smtp.ehlo( conn, 'mail.ppp.com' );

utl_smtp.command(conn, 'auth login');
utl_smtp.command(conn,UTL_RAW.CAST_TO_VARCHAR2(utl_encode.base64_encode(utl_raw.cast_to_raw('oooo'))));
utl_smtp.command(conn,UTL_RAW.CAST_TO_VARCHAR2(utl_encode.base64_encode(utl_raw.cast_to_raw('oooo'))));

utl_smtp.mail( conn, 'ppp@ppp.com' );
utl_smtp.rcpt( conn, email_in );

utl_smtp.data( conn,
'From: Rental' || utl_tcp.crlf ||
'To: ' || eremail_in || utl_tcp.crlf ||
'Subject: ' || 'Confirmation' ||
utl_tcp.crlf || 'Dear'||' '||name_in||' '||surname_in||','
||chr(13)||chr(10)||chr(13)||chr(10)||'Welcome'

utl_smtp.quit(conn);

END;

Message was edited by:
veledrom
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2008
Added on May 27 2008
1 comment
1,035 views