1) It is not necesary to DROP the trigger if you have a "CREATE OR REPLACE..."

2) You cannot do DML on the same table of the trigger.