Calling COM or DLL's from triggers ?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • David Pylatuk
    #1

    Calling COM or DLL's from triggers ?

    Is this possible in 8 or 9 ?

    Does anyone have an example ?

    Thanks


    Tags: None
    • Hans Forbrich
      #2
      Re: Calling COM or DLL's from triggers ?

      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

        Comment

        Previous template Next
        Working...