Home » Developer & Programmer » Forms » Sending Email through Oracle Forms 6i
Sending Email through Oracle Forms 6i [message #87844] Wed, 16 February 2005 09:40 Go to next message
Jay
Messages: 127
Registered: October 1999
Senior Member
Hello. I have a problem that I cannot seem to solve.

The requirements of a form are that when a button to commit records is selected, an email must be sent (in the background, without opening Outlook or opening another Canvas) to a recipient detailing some on the information presented from that form.

I've searched through the forums for some help, however, the topics I have read are either not exactly what I'm looking for or completely over my head (I'm a junior developer, in my second week, straight out of school). Any help provided would be greatly appreciated. If there is any further info required, please let me know.

Thanks in advance.
Re: Sending Email through Oracle Forms 6i [message #87866 is a reply to message #87844] Fri, 18 February 2005 01:14 Go to previous messageGo to next message
a
Messages: 22
Registered: March 2002
Junior Member
i have a code for the same (used in form 5 not in 6i) but i dont think it's i can explane it to u but if u want i can send it to u just reply if u want that code.
Re: Sending Email through Oracle Forms 6i [message #87871 is a reply to message #87866] Fri, 18 February 2005 06:55 Go to previous messageGo to next message
Jay
Messages: 127
Registered: October 1999
Senior Member
I'd really appreciate that. If you could send the code to jrai77@shaw.ca or post here, which ever is your preference. Thanks a lot!
icon14.gif  Re: Sending Email through Oracle Forms 6i [message #109191 is a reply to message #87866] Tue, 22 February 2005 16:44 Go to previous messageGo to next message
Matloob
Messages: 39
Registered: December 2004
Member
can u forward me the code on matloob84@gmail.com thanks
Re: Sending Email through Oracle Forms 6i [message #109217 is a reply to message #87844] Tue, 22 February 2005 23:23 Go to previous messageGo to next message
ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai
Member

file atteached pl find do reply

Razz Cool
  • Attachment: outlook.fmb
    (Size: 52.00KB, Downloaded 3607 times)
Re: Sending Email through Oracle Forms 6i [message #121435 is a reply to message #109217] Sun, 29 May 2005 06:39 Go to previous messageGo to next message
Gurusubramanyam
Messages: 79
Registered: July 2001
Member
Hi,

It's really cool & great. Thanks a lot for sharing your ideas. By the by, do you have any idea how to attach different types of files automatically?

Bye,
G.S
Re: Sending Email through Oracle Forms 6i [message #132993 is a reply to message #121435] Wed, 17 August 2005 03:49 Go to previous messageGo to next message
Ravi_prithiani
Messages: 14
Registered: July 2005
Location: Karachi
Junior Member

Its great .. it solved my problem but a little .. through this we can just mail to one person can anybuddy tell if i have to send mail to more than one peoples then .. how to do that? plz share its urgent ..

[Updated on: Wed, 17 August 2005 03:49]

Report message to a moderator

Re: Sending Email through Oracle Forms 6i [message #148795 is a reply to message #87844] Mon, 28 November 2005 04:04 Go to previous messageGo to next message
neom
Messages: 1
Registered: November 2005
Location: ireland
Junior Member
Thanks for the code, was very handy.

The default mail is microsoft office outlook 2003. I get the pop up window with the following message.
"A program is trying to automatically send e-mail on your behalf.
Do you want to allow this.

If this is unexpected, it may be a virus and you should choose 'No'".

In outlook express i found that there is a option under Tools->Options-> Security tab "Warn me when other application are trying to send mail as me".

Could not find similar option in outlook.
Can anyone let me know as to how could i suppress the pop-up window.




Re: Sending Email through Oracle Forms 6i [message #150036 is a reply to message #148795] Tue, 06 December 2005 01:27 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you considered using utl_smtp or utl_mail?

David
Re: Sending Email through Oracle Forms 6i [message #623509 is a reply to message #87866] Thu, 11 September 2014 01:02 Go to previous messageGo to next message
electrosoul456
Messages: 6
Registered: October 2010
Location: pakistan
Junior Member

Dear I need the code could you please send me on ali.khan@jamjoom.com

Re: Sending Email through Oracle Forms 6i [message #623510 is a reply to message #109217] Thu, 11 September 2014 01:06 Go to previous messageGo to next message
electrosoul456
Messages: 6
Registered: October 2010
Location: pakistan
Junior Member

Thanks buddy it is a nice solution Razz
Re: Sending Email through Oracle Forms 6i [message #677400 is a reply to message #148795] Tue, 17 September 2019 06:24 Go to previous messageGo to next message
faiza123
Messages: 1
Registered: September 2019
Junior Member
Hi for multiple recipients increase the char length of column :TO AND ADD MULTIPLE RECIPIENTS SEPARATED BY ; .In this way you can send email to multiple recipients.
Re: Sending Email through Oracle Forms 6i [message #677417 is a reply to message #677400] Wed, 18 September 2019 03:43 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Welcome to the forum.

Please note this thread is 14 years old. The OP is no longer going to be looking at it.
Re: Sending Email through Oracle Forms 6i [message #677630 is a reply to message #677417] Tue, 01 October 2019 09:33 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
check that working fine for me.

create or replace PROCEDURE send_mail (p_to IN VARCHAR2,
p_from IN VARCHAR2,
p_message IN VARCHAR2,
p_smtp_host IN VARCHAR2,
p_smtp_port IN NUMBER DEFAULT 25)
AS
l_mail_conn UTL_SMTP.connection;
BEGIN
l_mail_conn := UTL_SMTP.open_connection(p_smtp_host, p_smtp_port);
UTL_SMTP.helo(l_mail_conn, p_smtp_host);
UTL_SMTP.mail(l_mail_conn, p_from);
UTL_SMTP.rcpt(l_mail_conn, p_to);
UTL_SMTP.data(l_mail_conn, p_message || UTL_TCP.crlf || UTL_TCP.crlf);
UTL_SMTP.quit(l_mail_conn);
END;

execute send_mail(p_to => 'recipient_email',p_from => 'sender_email',p_message => 'This is a test message.',p_smtp_host => 'SMTP_HOST_NAME',p_smtp_port=>25);

PL/SQL procedure successfully completed.
Re: Sending Email through Oracle Forms 6i [message #677631 is a reply to message #677417] Tue, 01 October 2019 09:50 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
cookiemonster wrote on Wed, 18 September 2019 09:43


Please note this thread is 14 years old. The OP is no longer going to be looking at it.
Previous Topic: Sending Sms From Oracle data base Using Cellular mobile company API (merged 2)
Next Topic: pre-insert trigger
Goto Forum:
  


Current Time: Thu Mar 28 18:22:41 CDT 2024