Re: Help with DBMS_PIPE

good place to start is in the package header itself. look in $ORACLE_HOME/rdbms/admin/dbmspipe.sql or

	select text
	from dba_source  -- or all_source
	where name = 'DBMS_PIPE'
	and type = 'PACKAGE_BODY'
	order by line;

then check the Application Developer's Guide that comes with the Oracle doco.

Good books include Steven Feuerstein's Oracle PL/SQl Programming from O'Reilly, and the Oracle Press PL/SQL programming.

hth

-- 
Andrew - Wizzard

barnetaj_at_bp.com

Michelle Warner <delonda_at_radium.ncsc.mil> wrote in article
<352A450C.53A399F1_at_radium.ncsc.mil>...


> 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.

> 

> 

> 

>