Re: How To Trigger extern process from Oracle v7

From: Sandor Nieuwenhuijs <>
Date: Wed, 22 Dec 1993 10:23:45 GMT
Message-ID: <>

Michael Frank ( wrote:
: I believe that I had heard that you can
: use a trigger to do a 'system()'
: call in Oracle v7.

You cannot directly do system calls from triggers in Oracle7, but you can do basically the same using the DBMS_PIPES supplied packaged. Essentially you write your own C program, which communicates with the Oracle7 Server using this package (dbms_pipes.send() and dbms_pipes.receive() ).

Pages A-23 and A-24 of the Oracle7 Server Application Developers Guide shows and example of this feature.

Sandor Received on Wed Dec 22 1993 - 11:23:45 CET

Original text of this message