Why DBMS_CHANGE_NOTIFICATION [message #441665] Tue, 02 February 2010 09:28 Go to next message
Kevin Meade
Messages: 2102
Registered: December 1999
Location: Connecticut USA
Senior Member
Greetings all.

I ran across DBMS_CHANGE_NOTIFICATION recently. It looks interesting, but I have to ask, aside from refreshing data in some external cache, what good is this really.

I am sure someone can offer up "real world" uses for this database feature? This is just a query of interest. I have no project looking to use the feature yet.

Re: Why DBMS_CHANGE_NOTIFICATION [message #441668 is a reply to message #441665] Tue, 02 February 2010 09:40 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
Sounds like a nice way to create listeners that wait for messages, rather than procedural triggers.
I can see a lot of uses for this: compare it to a directory-listener that gets triggered if a file is added/changed/whatever.
Previous Topic: DB Design
Next Topic: Passing variable values within a CASE statement
Goto Forum:

Current Time: Wed Jul 26 17:49:01 CDT 2017

Total time taken to generate the page: 0.13254 seconds