Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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

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
Similar Threads
how to create trigger using java code
How to get auto increment value in Oracle table
Problem creating surrogate key
Want to call Servlet and PHP from oracle
Multi-row insert