Home » SQL & PL/SQL » SQL & PL/SQL » How to create email when you update the table (Oracle 9i)
How to create email when you update the table [message #319789] Tue, 13 May 2008 01:15 Go to next message
art_ora
Messages: 10
Registered: May 2008
Junior Member
Hi Everyone,
Can you please help me, on how to automatically email the client when you update the table.
How can I code the procedure that automatically email the user.
example when I update the status of table it call the procedure that automate to create an email and email to the user using microsoft outlook. How can i code using oracle sql.

thanks.
Re: How to create email when you update the table [message #319799 is a reply to message #319789] Tue, 13 May 2008 01:37 Go to previous message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at UTL_SMTP package to send email.
You can also search for "mail" on http://asktom.oracle.com.

To trigger this mail on update, you can use a... trigger.

Regards
Michel
Previous Topic: Convert string to date format
Next Topic: Locks
Goto Forum:
  


Current Time: Mon Dec 05 02:40:09 CST 2016

Total time taken to generate the page: 0.10165 seconds