Skip to Content
avatar image
Former Member

Oracle PUSH to Desktop App

Hi all,

I have an app which needs to report to users certain database criteria in real time.

So it sits there and constantly polls the database whenever a timer event fires (usually every minute).

Very wasteful of CPU cycles and network traffic.

So, instead, is it possible for the Oracle (or SQL Server) database to send a message to my desktop app whenever certain triggered updates occur?

Ideally, the database should trigger a user event in my app.

Is it possible to "register" an app with Oracle to make this work?

All other ideas are welcome. (someone suggested NET SEND).



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 28, 2015 at 03:31 PM

    Take a look at Oracle's Streams Advanced Queuing.

    From the guide (Sending Messages Using Oracle Streams Advanced Queuing)

    Oracle Streams Advanced Queuing (AQ) can notify an application and users when a message of interest is enqueued. Notifications enable applications and users to do their work without constantly checking a queue for new messages. Notifications can be sent to an application using PL/SQL, Java Message Service (JMS), or Oracle Call Interface (OCI) callback functions. Notification can also be sent to a specified e-mail address or HTTP post. In addition, notifications can be presented in either RAW data type form or XML form. Applications and users do not need to be connected to a database to receive notifications. When they are notified that a message of interest has appeared in a queue, they can connect to the database and check the queue.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      As alternative to your current situation of pulling, you could convert that pull to look at messages created by a DBMS_PIPE procedure.  You're still pulling, but it should be less noisy on the network. For a simple example, see DBMS PIPE - Oracle FAQ

  • avatar image
    Former Member
    Oct 28, 2015 at 11:23 AM

    Hi Larry;

       Oh yea .. <sigh> I wish we still had Distributed PowerBuilder (DPB) feature </sigh> as we could so easily do Server Push to client applications using that feature!   😢

       I wonder if you could modify Roland's "Chat" example that uses WinSock programming to do the trick ( Topwiz Software - PBChat )?

    Regards ... Chris

    Add comment
    10|10000 characters needed characters exceeded