Thank you all for your help. As you pointed out, Oracle built-in package
UTL_SMTP works well.
"Klaus Zeuch" <KZeuchnospam_at_hotmail.com> wrote in message
news:8psq02$fsp$1_at_papyrus.erlm.siemens.de...
> 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 - 16:16:25 CDT
