aD was notorious for forgetting to delete rows referencing tables in their drop scripts. My guess is that the Oracle script doesn't work, either. Have you tried it to see if it does?
As far as checking which drop is failing, try inserting RAISE statements after each PERFORM to log NOTICEs to stdout.
