Before Insert Trigger - Avoid Insertion
336287Jul 9 2003 — edited Jul 9 2003Hi,
I am having a table X. I would like to write a table level trigger (may be before insertion) so that I will skip insertion of some rows based on certain criteria and insert the same values in a audit table (for reconciliation later). I would like to do this with out raising any error message (i.e., Raise). In other words, user wont be knowing whether the data is being inserted in the main table or a audit table (which will hold the entries which are skipped). Is there any way to do this?
When i was trying to do this using after insert trigger....i am getting mutating. However I want to do this in before insertion because i don't want the entry to be done at the table level at all with out raising error.
Pl. advice.
Thanks and Regards,