Hi,
I am trying to send mail using utl_smtp from a pl/sql block. The message comes through fine but with no subject. Does anyone know how can I populate that ?
Here is the code I am using:
mail_conn := utl_smtp.open_connection(mailhost, 25);
utl_smtp.helo(mail_conn, mailhost);
utl_smtp.mail(mail_conn, 'from@xyz.com');
utl_smtp.rcpt(mail_conn,'abcd@xyz.com');
utl_smtp.data(mail_conn,mesg);
utl_smtp.quit(mail_conn);
Thanks in advance!
***Most problems are nothing but lack of ideas***
I am trying to send mail using utl_smtp from a pl/sql block. The message comes through fine but with no subject. Does anyone know how can I populate that ?
Here is the code I am using:
mail_conn := utl_smtp.open_connection(mailhost, 25);
utl_smtp.helo(mail_conn, mailhost);
utl_smtp.mail(mail_conn, 'from@xyz.com');
utl_smtp.rcpt(mail_conn,'abcd@xyz.com');
utl_smtp.data(mail_conn,mesg);
utl_smtp.quit(mail_conn);
Thanks in advance!
***Most problems are nothing but lack of ideas***