We're experiencing the problem in PLSD 6.0.2 using Oracle release 9.2.04. We started seeing the problem after installing Oracle Security Patch #68, but we haven't conclusively pegged that as the cause.

Reloading the package did not help, we resized the SGA and are waiting to see. The problem here is intermittent with various developers reporting the problem at different times.

Since the problem appears to be with the pipes implementation, I wrote a dummy application using DBMS_PIPES. Looping on a pipe read (dbms_pipe.receive_message) does make the application hang, but we don't get the 7445 error that we see when debugging is the source of the problem.

Any observations and comments y'all have are appreciated.