469,090 Members | 1,158 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

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

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
Jul 19 '05 #1
1 2426
mo******@ei.dupont.com (Mike Morris) wrote in message news:<3b*************************@posting.google.c om>...
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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by M | last post: by
6 posts views Thread by Michael Spiegel | last post: by
3 posts views Thread by takilroy | last post: by
9 posts views Thread by Oonz | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.