Re: Can a row add cause an email?

create a insert trigger on the table of interest.

1. from that trigger directly or via stored porcedure write into another table, which you have to poll periodicly with a select, query the data and create a email.
2. oracle 8.x has support for external procedures, call that procedure directly and create the mail from there. No polling involved, Oracle dependant.

it can't be done just by configuration, but with a programming effort.

regards
markus

Tyler Barnett wrote:
>
> I have an OLTP application that adds rows to a particular table.
> I would like to be notified by email that a row has been added to the
> table.
> The contents of the row itself would be great as the email subject or
> body.
>
> Oracle Support says this can't be done. Any ideas?
>
> Thanks,
> Tyler Barnett
> tbarnett_at_stdio.com
Received on Fri Jun 18 1999 - 02:20:17 CDT