File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "Oracle trigger" Watch "Oracle trigger" New topic

Oracle trigger

shivani anand
Ranch Hand

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

Joined: May 25, 2001
Posts: 65
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:
subject: Oracle trigger
It's not a secret anymore!