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