Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: System calls and asynchronized stored procedures?
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