Re: Sending a Page from PL/Sql

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 Wed Feb 10 1999 - 14:25:37 CST