What are you supposed to do when you need a trigger that checks for a certain :NEW value and then selects some data and calls a procedure if you can’t check for :NEW values in statement triggers and a row trigger makes the table mutating?
I have a solution, but it’s cumbersome. I really need this done by tomorrow morning. Pft. And Fame Factory is on at half past eight. I think I’ll bring the laptop home and write triggers while watching Fame Factory.
Voice in my head: Elton John and George Michael – Don’t Let the Sun go down on Me