Re: Sending a Page from PL/Sql

Hi,
 I think you are the man, Thanks for the reply. I am going to try this stuff. The problem with the enterprise manager option is that you can only one pager number. Iam looking for something along the lines of a 'Yahoo Pager'. I will kep you guys posted on the progress.

Cheers
Ven

black_orpheus_at_my-dejanews.com wrote:

> In article <36C10D05.3ADCBC5E_at_bidbazaar.com>,
> Venkatesh Kumar <vkumar_at_bidbazaar.com> wrote:
> >
> > --------------00B9918498EB08F58A5D1E69
> > Content-Type: text/plain; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > Hi,
> > Has anyone developed a PL/Sql script for sending a page to a person.
> > We need to develop this so that we can automatically page the DBA
> > incase a tablepdace is full or there is some other database problem.
> >
> > Thanks
>
> Well, Oracle Enterprise Manager has this functionality if you configure the
> Intelligent Agent and have a modem on the workstation running OEM. But, if
> you're a nut like me, there is a package called UTL_HTTP. This package
> (Oracle8) may be able to manipulate a web page to send a page to a pager. If
> you're on UNIX you may also be able to get a PL/SQL function to run an os
> command to cat a pager number to /dev/modem. The only problem is you need to
> have a procedure running at regular intervals to report on the status of
> value you are monitoring. Having a PL/SQL routine firing at regular intervals
> may cause some overhead on the database.
>
> Let me know if you try any of my crazy ideas. I'm just a little bored with
> convention so it might be nice to try something a little dangerous.
>
> -b
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sun Feb 14 1999 - 18:40:52 CST