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
- 1 Answers
- 5047 Views
- I also Faced
- E-Mail Answers
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 to create a new view in mysql? : Sql dba
How can you tell the difference between an index and a view?
What will you get by the cursor attribute sql%notfound?
What does pl sql developer do?
What is sql not null constraint?
How do you create a db file?
Why we use stored procedure instead of query?
Mention what pl/sql package consists of?
Does oracle use sql?
What is recursive stored procedure?
What is output spooling in sql*plus?
What are the benefits of pl/sql packages?
Why left join is used in sql?
How do you declare a user-defined exception?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
