Comments
| Database Triggers Overview - An introduction to database triggers in Oracle. |
poelger said... Maybe you should warn in your article about using non-transactional operations(package variables, autonomous transactions, ...) in triggers.Oracle can restart DML statements. I described this at our blog: https://iadviseblog.wordpress.com/2010/12/17/statement-restart/ And it is discussed on the Pl/SQL Challenge blog: http://plsql-challenge.blogspot.com/2011/02/dml-restarts-only-happen-with.html |
Tim... said... Hi.Good point. I've added it into the the "Should you use triggers at all?" section. Cheers Tim... |
lesio said... Very good article. DML restarts are kind of shock :p |
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!