Re: Waking up Pro*c prog.
From: Theresa Winter <twinter_at_nyx.cs.du.edu>
Date: 27 Jul 1994 08:57:29 -0600
Message-ID: <315skp$5tn_at_nyx.cs.du.edu>
Date: 27 Jul 1994 08:57:29 -0600
Message-ID: <315skp$5tn_at_nyx.cs.du.edu>
barth_at_newsserver (Juergen Barth) writes:
>Is there any chance to "wake up" a pro*c program if an action took
>place (i.e. Insert in an table) in the database.
>In database triggers you are only allowed to use SQL and PL/SQL
>commands.
>I work with Oracle 7.0.15 and SUN/OS 4.1.3
>Thanx Juergen
A pro*c program should be able to use the waitany procedure to wait for an alert which could be issued by an insert trigger. I don't have all the details, but plan to implement this soon. See page A-15 in the Server Applications Developers Guide for info on alerts and the waitany procedure. I'd be interested in hearing how it goes.
--
Theresa Winter
twinter_at_nyx.cs.du.edu
Received on Wed Jul 27 1994 - 16:57:29 CEST