Re: Trigger problem
Date: 9 May 2002 21:08:57 -0700
Message-ID: <16584988.0205092008.1aeab3b8_at_posting.google.com>
Hello JAgdeep,
It's difficult to predict what's happening exactly for certain
messages to get lost but one possible solution that you could try is
as follows :
1. Create a pl/sql table / array using a package
2. Put all the :new.Value in each element of the array through the
trigger
code that you've, for each row
3. Write another statement level trigger on this table (w/o each row
and
after update). The trigger would read each row in the pl/sql table / array
and do a dbms_pipe.send_message
Also, I'm not sure whether you handle exceptions that can arise while
using the dbms_pipe procedures / functions and check if there are
errors while packing,
unpacking, sending and receiving etc.
Regards
Bhooshan
Received on Fri May 10 2002 - 06:08:57 CEST