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_at_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 - 10:35:54 CEST

This message: [ Message body ]
Next message: sybrandb_at_yahoo.com: "Re: How can a 'non-owner' grant access to a table."
Previous message: Spiggy Topes: "LONGs with Oracle ODBC vs MS ODBC - Strange Translations"
In reply to: Mike Morris: "How to make a table insert trigger to hit a servlet?"
In reply to Mike Morris: "How to make a table insert trigger to hit a servlet?"
Next in thread: sybrandb_at_yahoo.com: "Re: How can a 'non-owner' grant access to a table."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message