Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Alert manager
Alert manager [message #77141] Sat, 18 September 2004 06:47 Go to next message
bhavin sanghani
Messages: 8
Registered: June 2004
Junior Member
Hi frnds,

I want to create one alert manager utility which will be monitoring database for events.

e.g. if purchase value > 10000/- then alert via e-mail should go to the relevant authority.

File is not uploaded to the file server by user.

questions are :

how can i fulfill this functionality ?

using which products ?

it will be configurable or need to do programming?

Expecting reply soon... Thanks....

-Bhavin Sanghani



Re: Alert manager [message #77143 is a reply to message #77141] Mon, 20 September 2004 16:24 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
One easy way is to create a trigger on the table having the new "purchased value" record, and have the logic in the trigger to handle your business rules.

You could also use Oracle Workflow but that is a much more complex solution. Typically you would also crease a trigger, or put some login in procedural code to "raise an event". Workflows subscribing to that event will contain your business logic. Although it may not involve pl/sql programming, you will program the business rules using the Workflow Builder tool.


-- Demo using events
Re: Alert manager [message #77149 is a reply to message #77143] Mon, 27 September 2004 05:38 Go to previous message
bhavin sanghani
Messages: 8
Registered: June 2004
Junior Member
Thanks andrew. you are right, Oracle workflow is much more complex solution....but is there any other option because we dont want to do much coding and testing on later stage...which is not the case with Workflow...using drag and drop operations other process can be easily defined....and we can include just name of the trigger in existing code....so, testing will not be much...

But if elegant solution is available then pls point me on that...because after installation client will expect more and more alerts...

Previous Topic: Calling Oracle store procedure from Buiness Object
Next Topic: ora-29276 transfer timeout
Goto Forum:

Current Time: Sat Feb 24 17:42:36 CST 2024