This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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!