Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: System calls and asynchronized stored procedures?

Re: System calls and asynchronized stored procedures?

From: pwe <pwe_at_trivadis.ch>
Date: Sun, 20 Dec 1998 13:01:27 +0000
Message-ID: <367CF526.5F201F81@trivadis.ch>

Jonathan Gennick wrote:

> On Fri, 18 Dec 1998 08:33:17 GMT, jListes_at_hotmail.com wrote:

> >- Make system calls (call a Shell script, copy files, send mails) from a
> >stored procedure?
>
> Not sure about this. I believe that in some implementations
> (Windows NT?) you can call functions in an external library,
> such as a DLL. Assuming that you can do that, then you
> coulld have the DLL invoke an O/S script. There may be
> better ways to approach this though.
>
> Jonathan

  You can do this with the "DBMS_PIPE" package on ORACLE 7.x. If you are running
  an ORACLE 8.0.x Server you can use callouts by defining "external procedures".

  It runs on Windows and on UNIX.

  peter Received on Sun Dec 20 1998 - 07:01:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US