Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!l41g2000cwc.googlegroups.com!not-for-mail
From: "Carlos" <miotromailcarlos@netscape.net>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Pinning a tcp connection in oracle.
Date: 4 Apr 2005 05:48:40 -0700
Organization: http://groups.google.com
Lines: 13
Message-ID: <1112618920.338593.164730@l41g2000cwc.googlegroups.com>
References: <1112398612.902769.292810@l41g2000cwc.googlegroups.com>
   <1112445304.463843.130230@l41g2000cwc.googlegroups.com>
NNTP-Posting-Host: 217.11.98.74
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1112618924 4395 127.0.0.1 (4 Apr 2005 12:48:44 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 4 Apr 2005 12:48:44 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: l41g2000cwc.googlegroups.com; posting-host=217.11.98.74;
   posting-account=v-zykAwAAADju6kwCHhel-_TxejVCoOK
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:117917

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.