Send an email from my Application forms [message #585611] |
Tue, 28 May 2013 06:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/379e55f070b5a4b7b6f328897bd559f9?s=64&d=mm&r=g) |
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 !!
|
|
|
|
|
|