OraFAQ Forum: Weblogic & Application Server

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Alert manager

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Alert manager [message #77141]

Sat, 18 September 2004 06:47

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

�

�

�

Report message to a moderator

Re: Alert manager [message #77143 is a reply to message #77141]

Mon, 20 September 2004 16:24

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.

http://download-west.oracle.com/docs/cd/B10501_01/workflow.920/a95265/demo02.htm#rap

-- Demo using events
http://download-west.oracle.com/docs/cd/B10501_01/workflow.920/a95265/demo39.htm#evdemo

Report message to a moderator

Re: Alert manager [message #77149 is a reply to message #77143]

Mon, 27 September 2004 05:38

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...

-bhavin

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 09:38:16 CST 2024