OraFAQ Forum: Forms » Send an email from my Application forms

Home » Developer & Programmer » Forms » Send an email from my Application forms (forms 10g,xp sp2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Send an email from my Application forms [message #585611]

Tue, 28 May 2013 06:21

goldray
Messages: 108
Registered: December 2012

Senior Member

Hi,
I want to send an email from my Application forms 10g .But I receive

code:
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 !!

Report message to a moderator