Home » Other » General » Generate Sound with Triggers - "Alarms" behavior (Oracle DB & MS SQL)
Generate Sound with Triggers - "Alarms" behavior [message #362027] Sun, 30 November 2008 01:03 Go to next message
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
Re: Generate Sound with Triggers - "Alarms" behavior [message #362037 is a reply to message #362027] Sun, 30 November 2008 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Generate Sound with Triggers - "Alarms" behavior [message #362038 is a reply to message #362037] Sun, 30 November 2008 01:55 Go to previous messageGo to next message
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
Re: Generate Sound with Triggers - "Alarms" behavior [message #362352 is a reply to message #362038] Tue, 02 December 2008 00:32 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Send an email. The email handler can 'beep'.

David
Re: Generate Sound with Triggers - "Alarms" behavior [message #382516 is a reply to message #362352] Thu, 22 January 2009 15:44 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://www.oracleutilities.com/Packages/dbms_alert.html
Previous Topic: who know Oralce iso calendar values?
Next Topic: Oracle Developer or DBA
Goto Forum:
  


Current Time: Fri Mar 29 07:16:44 CDT 2024