Home » SQL & PL/SQL » SQL & PL/SQL » Can not send mail thru pl/sql
Can not send mail thru pl/sql [message #247871] Wed, 27 June 2007 07:18 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: Can not send mail thru pl/sql [message #247884 is a reply to message #247871] Wed, 27 June 2007 07:45 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
http://www.google.fr/search?hl=fr&q=SMTP+error+553&meta=

Regards
Michel
Previous Topic: Error : ORA-01756: quoted string not properly terminated , when v insert
Next Topic: Sql Query
Goto Forum:
  


Current Time: Fri Feb 14 16:31:34 CST 2025