System calls and asynchronized stored procedures?
Quote:
>- Launch asynchronized stored procedures (executing in the background)?
You can do this using the DBMS_JOBS package. I believe it's
documented in the Server Administrator's Guide.
Quote:
>- 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
