Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help with DBMS_PIPE

Help with DBMS_PIPE

From: Michelle Warner <delonda_at_radium.ncsc.mil>
Date: 1998/04/07
Message-ID: <352A450C.53A399F1@radium.ncsc.mil>#1/1

Can anyone point me to some documentation on how to use the DBMS_PIPE utility.

Andrea Cannaos wrote:

> 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 Tue Apr 07 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US