Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Pushing event to client applications (Oracle , windows)
Pushing event to client applications [message #515241] Sat, 09 July 2011 02:55 Go to next message
dbuch
Messages: 7
Registered: July 2011
Location: Belgium
Junior Member
Hi all
I would like to know if there is a way to push an event to a client PC (Much like in Firebird /interbase which has events).
I want to be able to call an event from within a trigger to send out a notification to all listening client applications to inform them of a database update or insert etc.

I use Delphi as the front end to develop my clients and oracle 9 and up for the database.

thanks

Cheers

David
Re: Pushing event to client applications [message #515242 is a reply to message #515241] Sat, 09 July 2011 03:26 Go to previous messageGo to next message
John Watson
Messages: 8320
Registered: January 2010
Location: Global Village
Senior Member
Are your client applications logged on to the database? If so, DBMS_ALERT might be the simplest way. The docs give an example of raising an alert with a DML trigger.
Rgds, John.
Re: Pushing event to client applications [message #515249 is a reply to message #515242] Sat, 09 July 2011 06:12 Go to previous messageGo to next message
dbuch
Messages: 7
Registered: July 2011
Location: Belgium
Junior Member
Hi John

Thanks for your prompt response. i will check it out!

Cheers
Re: Pushing event to client applications [message #519482 is a reply to message #515249] Fri, 12 August 2011 17:30 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Maybe not exactly what you are looking for, but check out this fancy Apex reminder...

http://forums.oracle.com/forums/thread.jspa?messageID=9772980

Previous Topic: When Button Pressed in Apex
Next Topic: Inline error message for report region..
Goto Forum:
  


Current Time: Wed Aug 12 02:31:17 CDT 2020