OraFAQ Forum: General » Generate Sound with Triggers

Home » Other » General » Generate Sound with Triggers - "Alarms" behavior (Oracle DB & MS SQL)

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

Generate Sound with Triggers - "Alarms" behavior [message #362027]

Sun, 30 November 2008 01:03

bbaz
Messages: 138
Registered: April 2007

Senior Member

Hi all,

I am not sure where to create this topic, so I thought the GENERAL Forum would be the right place.

Although I am planning to get this Functionality with MS SQL Trigger but I believe it also Applies to ORACLE DB Triggers.

How can I generate a SOUND "BEEP" when a Trigger Fires on the DB? Our Objective is to Notify the User that there is something Major to act on.

The Trigger is Inserting a Record in a table when it Fires. So the BEEP will have to sound up when the record is inserted. When the User Updates a FLAG on the record, then the Sound should disappear.

Suggestions and Comments are much appreciated.

Thanks

Report message to a moderator

Re: Generate Sound with Triggers - "Alarms" behavior [message #362037 is a reply to message #362027]

Sun, 30 November 2008 01:50

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Trigger executes on SERVER, so no beep on CLIENT.
In addition, trigger is in PL/SQL and purpose of PL/SQL is not to interact with user.
Do this in the application side.

Regards
Michel

Report message to a moderator

Re: Generate Sound with Triggers - "Alarms" behavior [message #362038 is a reply to message #362037]

Sun, 30 November 2008 01:55

bbaz
Messages: 138
Registered: April 2007

Senior Member

Thanks Michel,

I was under this impression that the Logic should be done in the Application and on the Client Side.

I will check the code in the application.

Regards,
Baz

Report message to a moderator