Why wouldn't you simply use UTL_SMTP and DBMS_JOB for
scheduling mail from trigger so that it goes out asynchronously
or doesn't go out at all if transaction rolls back?
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Marc Lehmann" <marc.lehmann_at_fkd.bl.ch> wrote in message news:3D4656C5.9030402_at_fkd.bl.ch...
> Hello NG
>
> I would like to send an email using by using Java whenever some
> table-rows are changed. I guess I could use triggers therefore. however,
> i have not found any documentation or howto on this. can anyone help me
> with some useful links? note that i don't want to run a Servlet or JSP...
>
> Many Thanks for your help!
>
> regards
> Marc
>
Received on Tue Jul 30 2002 - 04:46:26 CDT
