Re: Help: Oracle Database Pipes

Byron,

The listener process can just be a PRO*C application that is polling the DBMS_PIPE stored procedure or another process that is polling the end of the pipe. As a request comes from the other end, the message is unpacked (ie. the arguments) and you can work with them internally.

What ORACLE has done is something called RPC-lite in that all of the networking has been pulled up into Oracle's SGA and if you are using SQL*NET, the networking is transparent to you.

We have found that this is good for simple requests, but when you have to push complex C data structures down the pipe, it is difficult to pack and unpack the PIPE beast. That is why we are looking at DCE.

I'm surprised that ORACLE reacted in such a way when you called. I have seen a couple of postings whereby people are using this PIPE in PRODUCTION applications.

Steve
Federated Investors
Pgh., PA.(We ain't a STEEL town anymore...) Received on Sat Jun 10 1995 - 00:00:00 CEST