Re: How to make a table insert trigger to hit a servlet?

From: <sybrandb_at_yahoo.com>
Date: 7 Jun 2004 01:35:54 -0700
Message-ID: <a1d154f4.0406070035.5a4eeeb5@posting.google.com>

morrisma_at_ei.dupont.com (Mike Morris) wrote in message news:<3b2c6993.0406040628.78e45e9_at_posting.google.com>...
> I have an app server running on top of Oracle 8i and need a way to
> have a table insert trigger call a servlet url in order to generate
> email to inform users of the event.
>
> I have seen references to "owa_util.redirect_url()" but when I use it,
> I get an unknown command error using sqlplus.
>
> Any help would be appreciated...
> Mike Morris

Please consider using the utl_smtp package. It won't require you to call out.

Sybrand Bakker
Senior Oracle DBA Received on Mon Jun 07 2004 - 03:35:54 CDT