Re: alerters? What are they, and how do I use them?

Almut Herzog wrote:
>
> Ken Frank wrote:
> >
> > Can anyone tell me anything about Oracle alerters?
> >
> > I've been told they are Oracle's equivalent to Ingres's
> > "dbevents", but haven't been able to find any more
> > information about them.
> >
> > Pardon the Ingres terminology, but this is what I want
> > to be able to do (we're porting our Ingres application
> > to Oracle):
> >
> > 1) Need to know how to "raise" an alerter from a
> > database procedure (one that is executed automatically
> > after an insert into a certain table).
> >
> > 2) Need to know how to "detect" these alerter-events
> > in a 'C' w/ embedded SQL "daemon" program.
> >
> > Thanks in advance!
> > Ken Frank
> > ken_at_mn.csoft.com
>
> You will find a description of the DBMS_ALERT (and DBMS_PIPE which is
> similar) in the "ORACLE7 Server Developer's Guide", p. A-15. There is
> sample code, too, which helped me very much to get started.
>
> --
> Almut Herzog
> SECTRA-Imtec AB e-mail: al-her_at_sectra.se
> Teknikringen 2 voice: ++46 13 235221
> 583 30 Linkoping fax: ++46 13 212185
> SWEDEN
There is also a product called Oracle Alert, which we found out about when looking at Oracle Financials. You might ask your Oracle rep. about more info. Received on Tue Aug 13 1996 - 00:00:00 CEST