aspose file tools*
The moose likes JDBC and the fly likes Oracle trigger Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle trigger" Watch "Oracle trigger" New topic
Author

Oracle trigger

shivani anand
Ranch Hand

Joined: Dec 28, 2000
Posts: 155
Can we create e-mail from oracle trigger? If yes How?
shivani
Bjarki Holm
Author
Ranch Hand

Joined: May 25, 2001
Posts: 65
Shivani,
I'm not sure if I understand you correctly, but one possible approach is to load a stored JavaMail program in the Oracle database, and have a trigger call a PL/SQL wrapper procedure that invokes the JavaMail, and effectively sends an e-mail message.
P.S. I covered this topic in detail in a book called Professional Oracle 8i Application Programming (ISBN: 1861004842), published by Wrox Press.

------------------
Bjarki Holm
Author of Professional Java Data


Bjarki Holm
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle trigger