automatic message notification [message #191644] |
Thu, 07 September 2006 07:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dmack
Messages: 42 Registered: March 2005 Location: TNT
|
Member |
|
|
Hi All
I would like to know if anyone knows of a way to send messages tgrough oracle developer. My problem is I have developed a progarm to log records relation to IT services, however if a request is logged and assigned to someone there is no way of notifying that person through the program. There is one way but this would involve logging in and out of the program and thie is not what I want. So is there any way of providing automatic/dynamic message notification using oracle.
I really hope someone can shed some light on this one.
thank you
|
|
|
|
|
Re: automatic message notification [message #192059 is a reply to message #191644] |
Sun, 10 September 2006 14:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
RJ.Zijlstra
Messages: 104 Registered: December 2005 Location: Netherlands - IJmuiden
|
Senior Member |
|
|
Hi Captain,
Besides the already mentioned methods, I suggest the following ( used in production about three/four yrs ago in 8i):
When you log the values in the table, put an after-insert trigger on that table, in which you can code for example: e-mail, sms some message.
Regards,
Rob Zijltra
|
|
|