Originally posted by TimHall
Remember, it's always better to put code into packaged procedures and call them from triggers rather than putting the codein a trigger directly.
And better then PL/SQL is to use SQL functions -- you avoid a costly context switch by doing so.