sending mail through clicking a button
636287Nov 12 2008 — edited Nov 12 2008hi,
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 123@abc.com .
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 .