DBMS_ALERT Package
you can use alerts to notify you about an event for informational purposes. The DBMS_ALERT package is typically a one-way asynchronous communication that is triggered when a transaction commits. Unless a transaction commits, no information is sent to the alert. This means that a waiting procedure or application remains idle until the desired transaction commits. [...]
Written by admin on January 19th, 2011 with comments disabled.
Read more articles on Oracle Packages.