Insert trigger to delete the row is just inserted

[boooble]

Hi,
I have an insert trigger which populates few other tables. After populating the tables i need to delete the row which got inserted( one which actioned the trigger). can this be done?

Would be great if someone can help?

Cheers,
Manoj

 

[dspare]

You might try this: Have the application which inserts the row which fires the trigger immediately delete the row it just inserted. That way the after insert trigger will have fired and done its work on all the other tables and the row you want deleted will be gone. Don't forget to do a commit in there somewhere.

 

[sem]

You may store PK of newly inserted row(s) in package variable and delete those records in after insert statement level trigger. The same way as with mutating error.

Regards, Dima