Re: dbms_pipe

Some considerations:

Are you creating the pipe explicity (CREATE_PIPE)?

>>C. Once that reader dies, you can still put data in the pipe.
Do you capture the return values of SEND_MESSAGE and EXCEPTIONs? If the reader 'dies' and the writer goes on SENDing, how is that the pipe doesn't reach the maxpipesize?

Do you SELECT from V$DB_PIPES when the reader 'dies' to see what's going on? There can be 'automatic pipe cleanout' issues.

Hope this helps.

Regards from sunny Spain.

Carlos. Received on Fri Apr 08 2005 - 02:26:00 CDT