OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Pushing event to client applications

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Pushing event to client applications (Oracle , windows)

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

Pushing event to client applications [message #515241]

Sat, 09 July 2011 02:55

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

Report message to a moderator

Re: Pushing event to client applications [message #515242 is a reply to message #515241]

Sat, 09 July 2011 03:26

John Watson
Messages: 8962
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.

Report message to a moderator