Trigger problem
Date: 1996/06/06
Message-ID: <4p6om2$ml4_at_athos.cc.bellcore.com>#1/1
Hi,
I have an oracle trigger that fires when an UPDATE takes place. The trigger body consists of the following:
BEGIN
IF UPDATING THEN
Value = :new.value;
END IF;
DBMS_PIPE.PACK_MESSAGE(Value);
n := DBMS_PIPE.SEND_MESSAGE('pipe_name');
END
The other end of the receiver is a Pro*C function that receives and
unpacks the message. The problem I am facing is that, whenever multiple
updates take place in a single transaction, say
UPDATE table_name ..... where id > 1;
I do not get all the updated values at the receiver end of the pipe. Some values get lost in the pipe. I have tried to increase the pipe size, but to no avail.
Could anyone help me with this. Thanks a lot for your time.
Jagdeep Received on Thu Jun 06 1996 - 00:00:00 CEST