Re: Execute C program from database trigger

From: Robert Cordingley <cord_at_ragesoft.com>
Date: 1997/03/12
Message-ID: <332a3274.28553892@news2.brainstorm.net>#1/1

On Wed, 12 Mar 1997 12:12:59 -0500, Lee Ewertz <ewertzld_at_usano.ksc.nasa.gov> wrote:

>I have a C program that communicates to another computer on the network
>and retrieves data from it. I there a way for a database trigger to
>execute the C program and access the data the C program retrieves?

>The C program does not execute and SQL.

If no C program executes any SQL then it can't be done, so far as I know. There's a package of PL/SQL and C stuff at Oracle's government site that will let you invoke other C programs through the interface created thereby. Other than that, you're outta luck, bud. Received on Wed Mar 12 1997 - 00:00:00 CST