Ora 04088 update

You can't query the table that caused a trigger to fire inside the trigger itself. But in this case, I don't see any need to. This can lead to massive bugs. Sending email is non-transactional. Once it's sent, it's sent.

If there's a mistake or error leading to a rollback, the email will still have gone. But the row won't have changed! If you can't do this easily , you could submit a job in the trigger that sends the email. The job will then be committed or rolled back with the update statement. Rating 3 ratings Is this answer out of date? I get compiler errors when I try to build this, it doesn't like the colon at the beginning Rookie mistake!

What if you were editing existing records? Would this work also? Yes, the trigger applies for insert or update , which is what you had. If you explicitly set a value for geometry in the insert or update statement then it would be overwritten by the value the trigger assigns, but I assume you're not planning to do that. Show 3 more comments. Amit Arora Amit Arora 1 1 gold badge 1 1 silver badge 7 7 bronze badges. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back But, when it hits else blocks it runs insert statements which are supposed to run.

Please look into below pseudo code. Expected Result: When I do update on T1, based on conditions it has to do inserts in else blocks only but not the insert statement of 1. A reader, November 18, - pm UTC. November 19, - am UTC. Hi All, I have write update code using merge and I have written Insert code as well.

It is working but while inserting if we modify any data then it is not reflecting.