I have and audit table to collection changes happening on an entity. This will be taken care by triggers.
During a batch test, I found that out of 1000 inserts into the main table, I got only 997 entries into audit table. I suspected that there might be a problem in the way I am accessing inserted tuple( I am reading only one record from inserted tuple and inserting that record into audit table). So, I changed my trigger code to create a temporary...