Re: Pinning a tcp connection in oracle.

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 4 Apr 2005 05:48:40 -0700
Message-ID: <1112618920.338593.164730@l41g2000cwc.googlegroups.com>

Another workaround that might work for you (it worked for me for connections to a mail server) is to create a process that opens the tcp connection and listens on a public PIPE (DBMS_PIPE) with some kind of LOOP.
The different procedures can PACK messages and SEND them to the public pipe, where the listener process can then RECEIVE the messages and send the data contained in the MESSAGE to the server using the (one) utl_tcp.connection.

Hope this helps.

Carlos. Received on Mon Apr 04 2005 - 07:48:40 CDT