Re: How To Trigger extern process from Oracle v7
From: Sandor Nieuwenhuijs <snieuwen_at_nl.oracle.com>
Date: Wed, 22 Dec 1993 10:23:45 GMT
Message-ID: <CIFM7L.LrA_at_nl.oracle.com>
Date: Wed, 22 Dec 1993 10:23:45 GMT
Message-ID: <CIFM7L.LrA_at_nl.oracle.com>
Michael Frank (frank_at_lgc.com) 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