Home » SQL & PL/SQL » SQL & PL/SQL » utl_smtp mail problem
utl_smtp mail problem [message #37250] Sun, 27 January 2002 23:19 Go to next message
gugan
Messages: 8
Registered: January 2002
Junior Member
i have some problem in sending mail from utl_smtp,

the thing is i'm able to send mail from utl_smtp but all the mails are coming without sendor's name and message.

any help?

regards,
gugan
Re: utl_smtp mail problem [message #37254 is a reply to message #37250] Mon, 28 January 2002 00:02 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

i guess u are not using correct syntax.

try this

conn := UTL_SMTP.OPEN_CONNECTION(v_mail_host,25);
--
UTL_SMTP.HELO(conn,v_mail_host);
UTL_SMTP.MAIL(conn,v_mail_sender);
UTL_SMTP.RCPT(conn,p_internet_address);
UTL_SMTP.OPEN_DATA(conn);

UTL_SMTP.WRITE_DATA(conn, 'From: '||v_mail_sender_name||' <'||v_mail_sender_address||'>'||crlf);
UTL_SMTP.WRITE_DATA(conn, 'To: '||p_internet_address||crlf);
UTL_SMTP.WRITE_DATA(conn, 'Subject: '||p_subject||crlf);

change the variables accordingly.

Hope it helps

cheers
pratap
Previous Topic: a problem about oracle error ora-06508
Next Topic: how java call pl/sql?
Goto Forum:
  


Current Time: Tue Jul 07 05:00:57 CDT 2020