Re: stored procedures/ database pipes

James McDonald wrote:
>
> Hello
>
> I have a question concerning database pipes and how they can be employed
> to create asynchronous messaging between stored procedures executing
> within an Oracle database server. The bottom line is that can one
> stored procedure listen on a pipe that another stored procedure can send
> data to.
>
> We have a requirement that our client must receive unsolicited messages
> from the server. My question is this: can one of these "listening"
> stored procedures execute within the Developer runtime environment,
> without the benefit of a database system on the client? Is there
> another way we can employ database pipes to listen at the client?
> Thank you.

Think of the "listening" as a process between two sesions in a database as opposed to a process between a database on the client end and on on the server end. As long as the client has established a session, your implementation of pipes on the client side can work with messages sent by server sourced connections or other client sourced connections. Regardless of where the connection started - the sessions all exist on the server side.

Cheers
TRG Received on Tue Aug 19 1997 - 00:00:00 CDT