Home » SQL & PL/SQL » SQL & PL/SQL » Unable to send mail thru PL/SQL
Unable to send mail thru PL/SQL [message #247823] Wed, 27 June 2007 05:36 Go to next message
kajarindam
Messages: 2
Registered: June 2007
Junior Member
Hi,
I am trying to send email by using the following procedure

l_mail_conn := utl_smtp.open_connection(l_vr_mailhost, 25);
utl_smtp.helo(l_mail_conn,l_vr_mailhost);
utl_smtp.mail(l_mail_conn,pi_sender);
utl_smtp.rcpt(l_mail_conn, pi_recipient);
utl_smtp.open_data(l_mail_conn);
utl_smtp.write_data(l_mail_conn, 'From: "' || pi_sender || '" <' || pi_sender || '>' || utl_tcp.crlf);
utl_smtp.write_data(l_mail_conn, 'To: "' || pi_recipient || '" <' || pi_recipient || '>' || utl_tcp.crlf);
utl_smtp.write_data(l_mail_conn, 'Subject: ' || pi_subject || utl_tcp.crlf);
utl_smtp.write_data(l_mail_conn, utl_tcp.crlf);
utl_smtp.write_data(l_mail_conn, pi_message || utl_tcp.crlf);
utl_smtp.write_data(l_mail_conn, utl_tcp.crlf);
utl_smtp.close_data(l_mail_conn);
utl_smtp.quit(l_mail_conn);


But while running it I am getting the following error for sending few mails
ORA-29279: SMTP permanent error: 553 header syntax error

I have checked that for the mail Id I am sending the mail is valid .Please help me.

Thanks
Kajarindam
Re: Unable to send mail thru PL/SQL [message #270628 is a reply to message #247823] Thu, 27 September 2007 12:35 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
ORA-29279: SMTP permanent error: 553 header syntax error
Did you set SMTP_OUT_SERVER parameter for mail server address.

Regards
Mohammed Taj
Previous Topic: LOB, BLOB, CLOB (merged by LF)
Next Topic: check constraint involving two column values
Goto Forum:
  


Current Time: Sun Dec 11 06:07:52 CST 2016

Total time taken to generate the page: 0.07470 seconds