Re: Alert, external UNIX process

From: Mike Gahan <ccaamrg_at_ucl.ac.uk>
Date: 1997/09/24
Message-ID: <34294350.446B@ucl.ac.uk>#1/1

Paul.deAnguera_at_ci.seattle.wa.us wrote:
>
> > Joerg Woelker <jwoelker_at_raie.de> writes:
> > Problem: We want to signal some Unix process an event out of Oracle
> > database, i.e. an update into a table.

Unix process connects to Oracle, listens on DBMS_PIPE. Setup UPDATE trigger to write down same DBMS_PIPE. Unix wakes up....

See PL/SQL documentation for DBMS_PIPE details.

-- 
    Mike Gahan 
    Information Systems Division
    University College London

    http://www.ucl.ac.uk/~ccaamrg/

Received on Wed Sep 24 1997 - 00:00:00 CDT