Re: Trigger problem

In article <AMI26kn0Q0_at_softserv.msk.ru>, Valery Yourinsky says... >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

Yes: there must be, since one cannot use :new or :old otherwise.

--
 _______________ ________________________ _____________
< Tommy Wareing X p0070621_at_brookes.ac.uk X 0865-483389 >
 =============== ======================== =============
/ If it's something I want, then it's something I need.\
| I wasn't built for comfort, I was built for speed!    |
\    -- Jim Steinman, Bad for Good                     /
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~