Tag: statement restart

On friday my quiz was on the PL/SQL Challenge. Topic: “Guidelines for Designing Triggers: Avoid Non-Transactional Logic in DML Triggers” Yes, about “statement restart” 🙂 My idea about the quiz was “making developers aware of the Oracle behaviour”. And I hope a lot of PL/SQL developers learned from it. It wasn’t easy to come up […]

Today I explained the “statement restart” problem to a colleague. Every database developer has to know about this one… Short: Any statement can be restarted! This means that when you do one update statement, oracle CAN restart the statement. Every code in a trigger can be executed multiple times, so watch out with package variables […]