Oracle & events

From: vejan (m.udina_at_libero.it)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 09:43:12 +0200

Hello!

I have a little problem. I have a real time form that has to read
data from the database and display it. Another program inputs data into
the database.

  CLIENT ---> ORACLE ->> REAL TIME FORM

is a small schema. The information is not mission critical but HAS to be
viewed at most 2 seconds after the insert in the db. The idea is to have
a trigger that sends some kind of information to the real time form. I
was thinking of doing it this way:
        - have a small program that holds communication on the server side
        - the real time form listens on the socket
        - the db trigger sends info on the socket
        
Are there any better ways?

Regards
        Mario Udina