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_at_edtnps84>
Date: Wed, 29 Sep 2004 23:54:32 GMT
Message-ID: <YWH6d.2537$eq.1185_at_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 Thu Sep 30 2004 - 01:54:32 CEST