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

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