Why DBMS_CHANGE_NOTIFICATION [message #441665] |
Tue, 02 February 2010 09:28 |
|
Kevin Meade
Messages: 2103 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.
Kevin
|
|
|
Re: Why DBMS_CHANGE_NOTIFICATION [message #441668 is a reply to message #441665] |
Tue, 02 February 2010 09:40 |
Frank
Messages: 7901 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.
|
|
|