| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Request for information on automated notification.
It does not have to be one-way (as in Oracle responsible for doing the
notification). You can use Dbms_System.Ksdwrt to write to alert logs. Then,
have a cron job (on UNIX) to read the contents of alert log from time to
time and write a special file in a pre-defined location, which can then be
picked up by a paging utility. We use a sub-set of this at our site.
Cheers,
Vasan.
-----Original Message-----
From: Thomas Day [mailto:tday6_at_csc.com]
Sent: 06 July 2004 16:21
To: oracle-l_at_freelists.org
Subject: Request for information on automated notification.
Aside from the utl_smtp package (I copied Jared's example) and the utl_tcp example that Omar Khalid posted here, does anyone have examples of ways that an Oracle database can automatically notify a user? This does not necessarily have to be via e-mail. Examples for pagers, cell-phones, PDAs, or whatever would be welcome.
Am I right in thinking that utl_tcp does not necessarily have to go to a mail server?
Because the Oracle database will be doing the notifying, it's assumed that I will know all the protocols and technologies that could be used.
This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you.
Churchill Insurance Group plc. Company Registration Number - 2280426. England.
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.
 |
 |