System calls and asynchronized stored procedures? 
Author Message
 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



Wed, 06 Jun 2001 03:00:00 GMT
 System calls and asynchronized stored procedures?

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

  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



Thu, 07 Jun 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Calling Stored Procedure that calls Stored Procedure in ASP

2. Calling a Java Stored Procedure from another Java Stored Stored Procedure

3. Stored Procedure calling Stored Procedure

4. Call a stored procedure from another stored procedure

5. calling system stored procedures

6. Calling System stored procedures

7. Still having problems calling system stored procedures

8. Display the first Field column that the System Stored procedure calls to display in my Datagrid

9. Calling SQL 7 System Stored Procedures: How?

10. Calling System stored procedures

11. making system calls from a trigger or stored procedure

12. Making system calls from a stored procedure


 
Powered by phpBB® Forum Software