RE: database events

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 23 Jan 2001 15:46:17 -0800
Message-Id: <10750.127335@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C08596.ADE57AA0
Content-Type: text/plain;

charset="iso-8859-1"

> -----Original Message-----
> From: Ajay Khandelwal [mailto:ajay_at_tems.com]
> Sent: mardi, 23. janvier 2001 15:12
> 
> I am trying to find out all possible ways I can signal agents 
> in my external
> system to notify about the database events.Like if there is any
> insert,update in a table I want to notify a proc*c ,c++ agent 
> about that.
> One solution is database pipe ,anything else ?
> Any other ideas ...

You can use database triggers to raise alerts using the dbms_alert package. A good discussion of the dbms_alert package can be found in "Oracle Built-in Packages", O'Reilly Press, authors Feuerstein, Dye and Beresniewicz.

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

------_=_NextPart_001_01C08596.ADE57AA0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: database events</TITLE>
</HEAD>
<BODY>

> -----Original Message-----
 > From: Ajay Khandelwal [<A =
HREF=3D"mailto:ajay_at_tems.com">mailto:ajay_at_tems.com</A>]
 > Sent: mardi, 23. janvier 2001 15:12
 > 
 > I am trying to find out all possible ways I can =
signal agents 
 > in my external
 > system to notify about the database events.Like =
if there is any
 > insert,update in a table I want to notify a =
proc*c ,c++ agent 
 > about that.
 > One solution is database pipe ,anything else =
?
 > Any other ideas ...

 

You can use database triggers to raise alerts using =
the dbms_alert package. A good discussion of the dbms_alert package can = be found in "Oracle Built-in Packages", O'Reilly Press, = authors Feuerstein, Dye and Beresniewicz.

------
 any ignorant comments made are the sole =
responsibility of J. R. Kilchoer and should not reflect adversely upon = my employer.

 
 Jacques R. Kilchoer
 (949) 754-8816
 Quest Software, Inc.
 8001 Irvine Center Drive
 Irvine, California 92618
 U.S.A.
 <A HREF=3D"http://www.quest.com" =
TARGET=3D"_blank">http://www.quest.com</A> Received on Tue Jan 23 2001 - 17:46:17 CST