The most current version has an alerting system in PL/SQL which can be
called anywhere. It can definitely interface with smtp, whether it also
supports paging I don't know, and you would need to verify that.
The package is called dbms_alert, Oracle documentation is up at
http://tahiti.oracle.com, free registration required. With the same
account you can also download for free the fully free and size limited
version of Oracle, Oracle 10g XE, or the full product Oracle 10g
Enterprise Edition.
You probably need the latter, as the smtp facilities interface with
Java and XE doesn't have Java.
Hth
--
Sybrand Bakker
Senior Oracle DBA
Received on Wed Feb 22 2006 - 06:13:56 CST
