Oracle 9i utl_tcp hangs entire db

Anyone else had problems with utl_tcp? Here are some comments from a developer in my group regarding a problem where our Sun Oracle9i DB hangs. Our management is on a mission to have us rip out our C language file and tcp net i/o in favor of these Oracle packages, with mixed results.

Thanks,

Peter

> I created a simple

pl/sql script that connects to one of my server processes and then calls utl_tcp.read_line to get data from that server (which will never send it data). While it is waiting, it seems to lock up the database or at least slow it down so much that it is unusable.

There is a solution, which is to use the utl_tcp.available call to determine if there is data available to read. This call returns immediately, so would have to be called in some sort of loop with sleeps in between. I modified my simple script to do this and database access seemed fine during the calls.

--
Posted via dBforums
http://dbforums.com