home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,788 of 2,288   
   Hans Forbrich to David Pylatuk   
   Re: Calling COM or DLL's from triggers ?   
   29 Sep 04 23:54:32   
   
   From: news.hans@telus.net   
      
   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 )   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca