Re: Trigger problem

jagdeep_at_cc.bellcore.com (Jagdeep Shiruru) wrote:

> 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
>
>...
>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.

   Is there 'FOR EACH ROW' in trigger header ?

Valery Received on Fri Jun 07 1996 - 00:00:00 CEST