Re: trigger to send email

If you prefer using pl/sql you can use package utl_smtp in 8.1.6 (java virtual machine jserver must be installed) - it's a wrapper around java classes.

hth

Klaus

C. Ferguson <c_ferguson_at_rationalconcepts.com> schrieb in im Newsbeitrag: 39C1AED9.D367297A_at_rationalconcepts.com...
> Or, here's another idea (since you are using 8.1.6). Haven't done this
 myself
> in the db, but write a java stored procedure to send mail using the java
 mail
> api. You will need access to an SMTP mail server from the database
 server.
>
> hth,
> cindy
>
> descmath wrote:
>
> > James wrote:
> > >
> > >
> > > Our development team want to send email to user whenever the user's
 record
> > > is updated. Is it do-able with Oracle 8.1.6? Thanks in advance.
> > >
> > >
> >
> > To do so, you have to make a system call to either sendMail (UNIX),
> > MAPISend (NT), or whatever email system you've got running.
> >
> > In 7.x, the way I sent mail was to write a control file (using UTLFile)
 to
> > the operating system (you can look in the sendMail documentation for the
> > format of this file.) Then I would have a chron job that fired every 15
> > minutes that executed the control files for any e-mails. This leaves up
 to
> > a 15 minute gap between the update and the e-mail.
> >
> > With 8, I understand you can call the execute separately, and get rid of
> > the delay.
> >
> > hope that helps.
> > kd
> >
> > --
> > Posted via CNET Help.com
> > http://www.help.com/
>
Received on Fri Sep 15 2000 - 03:55:10 CDT