Re: Active update monitoring (using pl/sql?)

"Kenneth Schulstad" <kschulst_at_ifi.uio.no> wrote in news:a22pps$aqn$1_at_maud.ifi.uio.no:

> I'm stumbled stuck with the following scenario:
>
> Oracle db running on a solaris server.
>
> I want the database to actively and immediately send some kind of
> message to an external application whenever a given table has been
> updated. This should preferrably be done using sockets or anything
> similar. The reason for this is that I can't afford having the
> application poll the db since that would mean too high a load on the
> network (If the external application should poll the db, this would
> have to be done _very frequently_ since the external application I'm
> developing must be as realtime-based as possible).
>
> The oracle db in question does not have any support for java (old
> version of oracle). Now, I'm a beginner to pl/sql, but was wondering if
> I could solve my problem (that is, getting the db to send a message to
> my external application whenever a table is being updated) using
> pl/sql? Does anyone have other suggestions on languages/techniques to
> use?
>
> I would be very grateful for any hints pushing me in the right
> direction, or any comments to my problem at all :)
>
> Regards
> Kenneth Schulstad
>
>
>

In V7 you can use DBMS_PIPE while having to write your own listener. In V8 (8i) you can use "external procedures. In 8i+ you can use Java.

FWIW - as soon as 8.1.6 which supported SMTP I create a small DB and wrote a small procedure which would send email messages. Then from any of my V7 instances, the just call this SMTP package & away goes the email message the V7 DB wants sent.

HTH & YMMV! HAND! Received on Tue Jan 15 2002 - 21:01:05 CST