Re: Trigger problem

From: Bhooshan Prabhu <bhooshan.s.prabhu_at_orbitech.co.in>
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

Original text of this message