Home » SQL & PL/SQL » SQL & PL/SQL » Why DBMS_CHANGE_NOTIFICATION (10GR2)
Why DBMS_CHANGE_NOTIFICATION [message #441665] Tue, 02 February 2010 09:28 Go to next message
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 Go to previous message
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.
Previous Topic: DB Design
Next Topic: Passing variable values within a CASE statement
Goto Forum:
  


Current Time: Thu Nov 07 17:05:46 CST 2024