Re: Calling COM or DLL's from triggers ?

From: Hans Forbrich <news.hans_at_telus.net>
Date: Wed, 29 Sep 2004 23:54:32 GMT
Message-ID: <YWH6d.2537$eq.1185@edtnps84>

David Pylatuk wrote:

> Is this possible in 8 or 9 ?
>
> Does anyone have an example ?
>
> Thanks

Calling out from the database is possible (both versions) - it's called EXTPROC or External Procedure. Check the Oracle documentation and OTN's Oracle By Example for examples and details (or take Oracle's Advanced PL/SQL course <g>)

Generally requires a PL/SQL 'call-out' and appropriate Oracle Networking setup.

Have to admit, I've never attempted it from a trigger. Between Oracle's UTL_TCP, UTL_SMTP, UTL_FILE, I've rarely had to use call-outs though.

/Hans Received on Wed Sep 29 2004 - 18:54:32 CDT