OraFAQ Forum: Forms » Sending alerts to all application users

Home » Developer & Programmer » Forms » Sending alerts to all application users

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

Sending alerts to all application users [message #130071]

Thu, 28 July 2005 01:29

sarfraz_attari
Messages: 123
Registered: July 2005

Senior Member

Is there any possiblity in forms 6/6i to send alerts to all application users when a particular condition is met or some error message fired

Sarfraz

Report message to a moderator

Re: Sending alerts to all application users [message #130077 is a reply to message #130071]

Thu, 28 July 2005 01:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Write the message to a database table, and in each form, as part of your corporate wide, object library have a default form level trigger that tests to see if there is a new meesage and then uses an alert to show it to the user.

David

Report message to a moderator

Re: Sending alerts to all application users [message #130092 is a reply to message #130077]

Thu, 28 July 2005 02:47

sarfraz_attari
Messages: 123
Registered: July 2005

Senior Member

thanks david for ur reply
but please can u explain me by giving some examples

Report message to a moderator

Re: Sending alerts to all application users [message #130096 is a reply to message #130092]

Thu, 28 July 2005 02:59

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If you want to broadcast something, you have to store it somewhere, then you have to have a form level trigger that fires everytime the user does something, like 'pre-text-item' or 'post-text-item'. You will have to have a flag mechanism so that you don't display the message every field change. For example, store in your user characteristics table the last message displayed, then check to see if the new message is greater than the stored number, if it is greater display the alert and update the user details using an asynchronous update otherwise you may inadvertently commit data that the user does not want committed.

Alternatively, just have a changeable message on your 'flash' screen and show it when the user returns to the 'flash' screen.

David

Report message to a moderator

Re: Sending alerts to all application users [message #130102 is a reply to message #130071]

Thu, 28 July 2005 03:20

oraclejo
Messages: 50
Registered: July 2005
Location: Ammar

Member

hello

Nothing straight forward, however,

Oracle Kernel contains several mechanism to accomplish similar ideas, most of which require elaboration

1- It is easy to send email from within an Oracle Trigger, refer to UTL_TCP, and MAIL packages in Oracle Packages

2- Use Oracle DBMS_PIPE techology, where an form event dispatches a message to a pipe, a client can then retrieve the message by reading the pipe

3- Use Oracle AQ (Adv Queueing) where the client can repsond to an event by enqueing a message to be later Dequeued by the receipient.

4- If you are into JAVA then you can craft RMI (remote method invokation) technique though a database trigger or a stored procedure. A java client can be written to sense the invokation and in turn use JNI to write the Alert, I once did that by creating a small VB form that simulates an MSN Alert (when somebody logs into SMS, you see a small window poping up).

The user then would see such window poping up when a certain condition occurs

5- if you want a table based approach, you might as well incorporate Oracle Workflow engine

hope that gives you an idea what to choose and where to start

Regds

Ammar Sajdi
www.e-ammar.com

Report message to a moderator

Previous Topic:	SMTP!!!!
Next Topic:	to check values in multirecord

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 04:25:02 CST 2025