Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
sending mail through clicking a button
hi,
I am using oracle developer suite 10g and oracle database 10g.
the problem is like this , I have a table named emp which has two columns
employee_id number primary key,
and last_name varchar2(20) ;
I have two text boxes names :block3.text_item8 and :block3.text_item9 , and a push button named push_button4;
when I click on the button the data inside the text_boxes will be saved in the emp table as declared and also a mail will be sent to an email address which will be provided through another text_item :block3.text_item10 in the format say [email protected] .
I can save the data after clicking the button through simple dml queries , but I am not able to send the auto genearted mail which will send a message to that e-mail address that an entry with this mail account has been made .
could you please help me with a step by step procedure to do this.
Thanx for your interest .
I am using oracle developer suite 10g and oracle database 10g.
the problem is like this , I have a table named emp which has two columns
employee_id number primary key,
and last_name varchar2(20) ;
I have two text boxes names :block3.text_item8 and :block3.text_item9 , and a push button named push_button4;
when I click on the button the data inside the text_boxes will be saved in the emp table as declared and also a mail will be sent to an email address which will be provided through another text_item :block3.text_item10 in the format say [email protected] .
I can save the data after clicking the button through simple dml queries , but I am not able to send the auto genearted mail which will send a message to that e-mail address that an entry with this mail account has been made .
could you please help me with a step by step procedure to do this.
Thanx for your interest .
Tagged:
Answers
-
Hi Sourav,
What is the code u r using to send the mail. In general utl_smtp is used to send the mail. For further information u can search in this forum, where in we've many examples. If u've written any code then do display the code. so that any one of us can help you.
Regards,
Alok Dubey -
Hello,
There are several options for sending email.
1) Write a stored procedure using utl_smtp or utl_mail (new with 10g). This is the easiest to implement. See for example: www.psoug.org/reference/utl_mail.html
Problems you can have here: your smtp server does not allow you to send email or won't relay emails from your side. Most problems I have seen with this implementation were related to the smtp server.
2) Use the javamail PJC/javabean from the Oracle PJC demos. This one is a bit easier to implement but does require some preliminary setup. You might have to check the smtp server again and make sure it can relay your emails.
Hope this helps. -
a third option is to use OLE (or CLIENT_OLE in 9i, 10g) and send the mail via outlook.
This discussion has been closed.