Re: Can PL/SQL make a system call?

vera_at_mda.ca (Felipe Vera) wrote:

> Hello,
>
> Can someone tell me whether a PL/SQL stored procedure can call the Unix
> system() function. Or is there any other way to invoke an external
> appliation?
>

We have to get a FAQ posted here someday...

Have a look at DBMS_PIPES and/or DBMS_ALERTS. Can't do the system call directly, but one of the above will certainly facilitate it.

hth,

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Chris Kasten
Programmer/Analyst

#include <std/disclaimer.h>
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Received on Mon Apr 01 1996 - 00:00:00 CEST