Re: DBMS PIPE

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:

1. Write a 3GL (eg in C) that runs (ie polls) on the server and waits for incoming requests from dbms_pipe.
2. 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 Martin