Re: Waking up Pro*c prog.

In article 4rd_at_nameserver.lif.de, 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

I haven't tried it from a trigger yet, but I've used an Oracle Pipe between other Oracle processes. The receiver will "block" awaiting a packet, and then continue on its merry way. That might help.

Good luck.

Sincerely,

Martin Farber
Independent Oracle Consultant

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1D10
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216