Re: DBMS PIPE

Connor McDonald wrote:
>
> Cheryl Henry wrote:
> >
> > I posted to this newsgroup about 2 weeks ago. The article was about
> > running commands that are on my server (VAX) from my pc (using
> > Dev2000/Win95). Someone replied about using a DBMS_PIPE. Any information
> > about this will be greatly appreciated. Thanks!
>
> I haven't done it but the basic bits and pieces are:
>
> a. Write a 3GL (eg in C) that runs (ie polls) on the server and waits
> for incoming requests from dbms_pipe.
> b. Then dbms_pipe sends a message which is picked up by the 3GL and
> runs the appropriate server commands.
>
> I saw a white paper on it somewhere - I think on the Oracle home page
> (www.oracle.com) or the Oracle magazine (www.oramag.com)
>
> Cheers
> --
> Connor McDonald
> Systems Administrator-Unix/Oracle
> BHP Iron Ore
> "You're not drunk if you can lie on the floor without holding on"
> - Dean MartinA good reference on DBMS_PIPE and other build-in packages is Oracle
Press PL/SQL Programming Chapter 9 Intersession Communication. These books can be found on the web at http://www.osborne.com. Dennis
Kennedy Space Center Received on Tue Mar 04 1997 - 00:00:00 CET