Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: APPLICATION EVENTS

Re: APPLICATION EVENTS

From: Ronald <spamm_somewhere_else_ronr_at_worldaccess.nl>
Date: 1997/04/23
Message-ID: <spamm_somewhere_else_ronr-2304972005020001@news.worldaccess.nl>#1/1

In article <335780F1.7C0B_at_csc.com>, Bob Yeh <tyeh_at_csc.com> wrote:

> NNOOR wrote:
> >
> > Does Oracle has alerters/application events/messages (what ever
> > you wanna call it)? We want somethings to happen in our client
> > application based upon some events in the DB Server. What is
> > the best way to implement it---short of writing a process which
> > queries the DB every so few seconds?
> >
> > Thanks very much!
> >
> > regards,
> > --nasir (nnoor_at_cris.com)
>
> Check out Oracle dbms_alert package. It client application can register
> with server and wait for the alert to happen.
>

One problem with dbms_alert is that it blocks other processes that try to signal the same alert until the first process commits/rollsback.

Ronald

mailto:ronr_at_worldaccess.nl
http://www.worldaccess.nl/~ronr (last update march 15. 1997) Received on Wed Apr 23 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US