Re: bepper trigger??

Actually, it is fairly easy but you'd have to have the hardware to support dialing the pager.

Here is one possible solution:

Have a daemon running which will constantly poll a table for entries. When the operator presses the "button" the application would put an entry into the table. The daemon then reads the row and through whatever logic is necessary figures out what pager to dial. It then dials that pager, sends whatever information is needed and then hangs up. If you want the page to be a one-shot deal, delete the entry in the table. Otherwise re-page every X minutes until a response is received. The respondee would then take manual action to delete the entry and the paging would stop. Using this scenario you could have different pager numbers dialed depending on time of day, originiating operator, severity of problem, etc.etc - whatever you want. The thing is, you really can't do it directly from pl/sql iself, but you can do it asychronously via another program that can read an entry from an oracle table.

There is one exception to this - if you are running an Oracle Forms application then you can write a user-exit and the user exit program can do the paging sychronously.

Ken

Munish wrote:

> Hi,
> I am running oracle developer 2000 v 5.0. I was wondering is there
> any trigger or if some one has a piece of code.. that will let me beep
> a particular person right from the form.
>
> The issue is this.. If there arises an emergency, and the helpdesk
> person enters the information, and I am not in the office to answer
> calls, there should be a way,,, by which she can press a button on
> the form and it will beep me..
>
> Any help will be appreciated
> Munish
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jun 18 1999 - 12:05:09 CDT