Hi all,

I have this send_mail procedure:

CREATE OR REPLACE PROCEDURE LIS.send_mail (v_sender IN VARCHAR2,
v_recipient IN VARCHAR2,
v_subject IN VARCHAR2,
v_message IN VARCHAR2)
as
l_mailhost VARCHAR2(255) := '111.11.1.111';
l_mail_conn utl_smtp.connection;
crlf varchar2(2):= CHR(13)||CHR(10);
mesg varchar2(4000);
BEGIN
l_mail_conn := utl_smtp.open_connection(l_mailhost, 25);
mesg:= 'Date: '||to_char(sysdate,'dd Mon yy hh24:mi:ss' )||crlf
||'FROM: '|| v_SENDER ||' >'||crlf||'Subject: '||v_SUBJECT|| crlf ||'To: '
|| v_RECIPIENT || crlf ||' '|| crlf || v_MESSAGE;
utl_smtp.helo(l_mail_conn, l_mailhost);
utl_smtp.mail(l_mail_conn, v_sender);
utl_smtp.rcpt(l_mail_conn, v_recipient);
utl_smtp.data(l_mail_conn,mesg);
--utl_smtp.write_data(l_mail_conn, v_message);
--utl_smtp.close_data(l_mail_conn );
utl_smtp.quit(l_mail_conn);
end;
/


it's been working fine for the last couple of months and all the sudden it stops working. We have not changed anything on the mail server, nor the database. The Ipaddress of the mail server is correct. I could not think of anything else why this procedure is not working and I got the above errors.

any advise???

thanks