11 Replies Latest reply: May 30, 2013 9:22 AM by CraigB RSS

    Send an email from my Application forms

    Goldray
      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