Re: Calling DLL's from Triger

Mark Spiteri <fotolux_at_pathcom.com> wrote in article <01bb8c7d$1f5b5320$427abfcc_at_steve>...
> Hi there,
> Is it possible to call a DLL from within a Triger. If it is
 possible
> please let me know. Also if anyone has some saample code on how to do
> this, I would greatly appreciate a copy of it.
>
It is not possible to call a DLL from anywhere inside Oracle, although, I am told that this functionality will be available in Oracle8. However, there is the dbms_pipe package. To get around the inability to call external code, one must create a program that logs into oracle, and listens to a pipe, other oracle sessions can send messages to that pipe (all through the dbms_pipe package) and the logged in program can then perform the process. Not exactly elegant, but it does seem to work. The Application Developers Guide for V7.2 contains an example.

Hope this helps
David Devejian
djd_at_bank2000.com Received on Mon Aug 19 1996 - 00:00:00 CEST