RE: Request for information on automated notification.
- From: Srinivasan Vasan <Vasan.Srinivasan@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Jul 2004 16:45:30 +0100
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@xxxxxxx]
Sent: 06 July 2004 16:21
To: oracle-l@xxxxxxxxxxxxx
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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
___________________________________________________________________________
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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
