Re: sending events from database to forms client

From: Ken Shirey <kshirey_at_commercial-data.com>
Date: 1998/01/28
Message-ID: <01bd2c1b$debcdba0$c7e940c6_at_kshirey>#1/1

Three ways come to mind:

PASSIVE:

---

Create a queue table and scan it at intervals (via timer?) for your job/event...

ACTIVE:

---

  blocking:

        use DBMS_ALERT package and wait for the alert. Your client will be frozen while waiting.
  non-blocking:

        use DBMS_PIPE and check your (named) pipe for a message from the other end.

        Have the server process write to the pipe whenever it has something to say.

Hope this helps...
Ken

MAS Regensburg <mas.r_at_t-online.de> wrote in article <6akkh8$lvn$1_at_news02.btx.dtag.de>...
> Does anyone know how to send events from database to a forms client?
> Any help is appreciated.
>
> mas.r_at_t-online.de (Reinhard Basl)
>
Received on Wed Jan 28 1998 - 00:00:00 CET