Re: sending mail via a trigger

Hi,

utl_smtp was introduced with 8.1.6 (8i Release 2) - Mike is on 8. If Oracle 8 is run on Unix the sendmail command can be used - there's an example in Oracle metalink. For Oracle 8 on NT one solution is described at http://www.ipass.net/~davesisk/oont_download.htm (SendMailFromDB)

Klaus

"Tom Best" <tom.best_at_bentley.com> schrieb im Newsbeitrag news:8mcgui$2oi$1_at_news.bentley.com...
> Mike:
>
> Take a look at the UTL_SMTP package.
>
> HTH,
> Tom Best
>
> <myro1_at_my-deja.com> wrote in message news:8mcdhm$67h$1_at_nnrp1.deja.com...
> > I'm trying to write a trigger that will send an email notification
> > on every insert into a specific table. This doesn't appear to be an
> > easy task with Oracle 8, but I would guess it's somewhat common
> > so certainly someone has tackled this before.
> >
> > Any help would be appreciated.
> >
> > Thanks,
> > Mike
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Thu Aug 03 2000 - 00:00:00 CDT