Re: Trigger external program in Oracle

You can achieve this by writing a program that runs at OS level, in a language that support embedded PL/SQL. Through PL/SQL you connect to the database, and wait for a message in a pipe. When your program receives this message, you end the PL/SQL and start the external program. You could place the PL/SQL inside a loop, so taht after starting the external program you wait for the next message. In the DB trigger all you have to do is put a message in the pipe.

Good Luck!

Jack

Wei Tang <wtang_at_cs.ualberta.ca> wrote:

>Hi, there:
>
>I wonder if Oracle DB trigger has the ability to trigger external
>programs instead of only trigger a PL/SQL block or a stored
>procedure. If so, it will save me a lot of effort. What I am doing is to
>let the trigger start a email alerter whenever the
>content of a table satisfies some conditions.
>
>I cannot find any documentation about this.
>
>Thank you very much.
>
Received on Sat Jan 24 1998 - 00:00:00 CST