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

Kenneth Schulstad wrote:
>
> 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

Some options:

• dbms_alert
• dbms_pipe
• external procedures
• java
• advanced queuing option

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."