Re: Calling a Shell Script from a Stored Procedure

From: Andrea Cannaos <Andrea.Cannaos_at_deagostini.it>
Date: 1998/04/06
Message-ID: <352905C0.EC8FA6F7@deagostini.it>#1/1

Michelle Warner wrote:

> I need to call a shell script from a stored procedure. Currently I
> have:
> HOST (host_line);
>
> host_line contains the call to the shell script with its parameters.
> The stored procedure does not execute - does not know what HOST is.
>
> Michelle

The only way I know is writing a daemon(maybe in PRO-C) and establish a communication between your stored procedure and this daemon using DBMS_PIPE. Your procedure can send to daemon the request to execute theSHELL.

It works. Received on Mon Apr 06 1998 - 00:00:00 CDT