Re: Execute C program from database trigger

From: RYoung <ryoung_at_summer.dbsol.com>
Date: 1997/03/13
Message-ID: <01bc2f57$99dba460$ef428ad0@pc060.groupZ.net>#1/1

I've seen people use dbms_pipe() to control a script that can call a C/Fortran/etc program, but I dont know if it can return information this way.

UTL_FILE is a package in PLSQL that allows for PLSQL to read/write operating system files. This would give you a way of transferring the information into say, a PLSQL 'table'.

You might also have the C program store the information it is returning into a temporary table inside the database using ProC from Oracle. The PLSQL could access it directly.

You would only then have to sync the two which could be done in a number of ways . ...

Robert Cordingley <cord_at_ragesoft.com> wrote in article <332a3274.28553892_at_news2.brainstorm.net>...
> 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?
>
Received on Thu Mar 13 1997 - 00:00:00 CST