Re: Trigger problem

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