You might use javamail if you wanted to do stuff you can't (reasonably) do
with utl_smtp (attachments etc).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message
news:ai5n9j$sor$1_at_babylon.agtel.net...
> 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_at_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:59:55 CDT
