Re: Can C programs be invoked from triggers?

John Morgan (John_Morgan_at_OIT.PeachNet.EDU) wrote:
: In article <381drl$668_at_ixnews1.ix.netcom.com> George Svedloff,
: svedloff_at_ix.netcom.com writes:
: >This is a very good question that I have been trying to find an answer
 to for some
: >time. If anybody knows anything about this, it will be greatly
: appreciated.
 

: Yes...you must use the DBMS_PIPES (v7). Create a stored procedure that
: the trigger executes. The procedure then places a set of code on a named
: pipe. The C program is "listening" to this pipe for instructions. I use
: it to pass UNIX system commands out to be executed.

I am not sure you got the question quite right -- he asked if he could call a c program, not communicate with one. As to calling, the answer is no when you refer to database triggers. But the above mentioned solution will work if you want ot have your c program loop infinitely and check the pipe each time through the loop :)

Hopefully the next release of PL/SQL will have a host capability. Also, better signalling would be nice.

Jonathan, who prays for better Oracle every day :) Received on Thu Oct 20 1994 - 02:53:19 CET