Re: Waking up Pro*c prog.
From: Martin Farber <farber_at_nynexst.com>
Date: 27 Jul 1994 20:37:01 GMT
Message-ID: <316ghd$73_at_news.nynexst.com>
Date: 27 Jul 1994 20:37:01 GMT
Message-ID: <316ghd$73_at_news.nynexst.com>
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-2216Received on Wed Jul 27 1994 - 22:37:01 CEST