Answer / gourvendra singh

Hi,

this can be done, i can not send u the exact code but
following steps can help you out.

-- Create a procedure with following code in mailhost you
have to enter the IP of the mail server :

CREATE OR REPLACE PROCEDURE LEAMIGR_BAFLAF.email(p_target
IN VARCHAR2, p_subj IN VARCHAR2, p_message IN VARCHAR2) IS
--PURPOSE: SEND p_message TO p_target VIA EMAIL.

v_eol VARCHAR2(2) := chr(13)||chr(10); -- EOL CHARACTERS
v_sender VARCHAR2(50) := 'sender@mail.com';
mailhost VARCHAR2(35) := 'mail@mail.com';
mail_connection utl_smtp.connection;

BEGIN
-- ESTABLISH CONNECTION AND PERFORM HANDSHAKING
mail_connection := utl_smtp.open_connection(mailhost,25);
utl_smtp.helo(mail_connection,mailhost);
utl_smtp.mail(mail_connection,v_sender);
utl_smtp.rcpt(mail_connection,p_target);

-- BUILD THE MAIL MESSAGE AND SEND IT OUT
utl_smtp.mail_connection
('Subj:'||p_subj||v_eol||v_eol||p_message||v_eol);

-- SEVER THE CONNECTION
utl_smtp.quit(mail_connection);

EXCEPTION
WHEN OTHERS THEN
RAISE_APPLICATION_ERROR(-20002,'ERROR IN EMAIL
=> '||SQLCODE||':
'||SQLERRM);
END;

-- Now create a trigger on the table where the insert
operation is happining and on post insertion call the
procedure with the mail id of the user to whom you want to
send a mail.

I think this will work.

for any query can contact at:
raviindian2114@gmail.com

Which table is left in join?

0 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---

How do you use a while loop in pl sql?

0 Answers  

---

explain the delete statements in sql

0 Answers  

---

How do I view a sql trace file?

0 Answers  

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

Is left join and outer join same?

0 Answers  

---

What is the purpose of normalization?

0 Answers  

---

How do I find duplicates in two columns?

0 Answers  

---

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---