Recent content by manninga

We lost another message this morning. I checked our debug table, and the return status of the pipe message insert was 0. The pipe and application were both sitting idle for some time before and after the lost message. Here are the results of the trigger's debug table and the application log...

I will update the trigger to check for the return value.

I know there isn't anything else reading the pipe. Based on the content of the message added to the pipe, I don't see how any error could occur on sending. I would suspect that any error sending the message would cause the trigger to fail and not continue inserting the message into the...

We are currently using the latest DOA package in our Delphi 7 environment. Over the past few months we have seen an increase in pipe messages being lost. Our main Oracle table fires a trigger when a new record is inserted. This trigger first calls dbms_pipe.pack_message() and then inserts the...