Re: Help with DBMS_PIPE

Also, coming soon to bookstores:

"Oracle DBMS Packages" (Feuerstein, Beresniewicz, Dye) O'Reilly & Associates.  The pre-release comments on this book have been excellent.

It will be available at the Illuminations Bookstore (http://www.illumine.com)

Cam White
RevealNet, Inc.

In article <01bd628c$4bba83a0$8c0564a1_at_azmelw1358.mel.az.bp.com>,   "Andrew Barnett" <nobody_at_spamandeggs.bp.com> wrote:
>
> 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.
> >
> >
> >
> >
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Apr 08 1998 - 09:43:17 CDT