hi
sql gurus, here is my question 4 u.
i wanna use triggers for sending reminder mail to all users
who are registered to the site. if any one knws the code plz
send me ans here : chayabs3@gmail.com
thnx advance
Answer Posted / 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
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How do I find duplicates in two columns?
Is big data nosql?
What is the need of merge statement?
What is difference between db2 and sql?
What are the types of join and explain each?
What are sql triggers used for?
What are keys in sql?
What is %rowtype in pl sql?
What is the use of function in sql?
differentiate between float and double. : Sql dba
what is oracle database ? : Sql dba
Can we join tables without foreign key?
Define commit, rollback and savepoint?
Is mariadb a nosql database?
what is a tablespace? : Sql dba