This discussion is archived
11 Replies Latest reply: May 30, 2013 7:22 AM by CraigB RSS

Send an email from my Application forms

982158 Newbie
Currently Being Moderated
Hi,
I want to send an email from my Application forms 10g .But I receive

code:when-pressed-button trigger
DECLARE
l_mailhost VARCHAR2(64) :=... //admin mail
l_from VARCHAR2(64) := ... //admin mail
l_to VARCHAR2(64) := ...//user mail
l_mail_conn sys.UTL_SMTP.connection;
BEGIN
l_mail_conn := UTL_SMTP.open_connection(l_mailhost, 25);
UTL_SMTP.helo(l_mail_conn, l_mailhost);
UTL_SMTP.mail(l_mail_conn, l_from);
UTL_SMTP.rcpt(l_mail_conn, l_to);
UTL_SMTP.data(l_mail_conn, 'HELLO' || CHR(13) || CHR(13));
UTL_SMTP.quit(l_mail_conn);
message('mail sent');
message('mail sent');
exit_form(no_validate);
exception when others then
message('no internet connection');
message('no internet connection');
END;


message displayed is: no internet connection !!

Edited by: 979155 on 28 mai 2013 04:13

Edited by: 979155 on 28 mai 2013 04:28

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points