I don't like the constraints on Web Service Security (ws_webservicetype) because if you want to delete an entry in the main tab of the window, you get errors if there are still parameters/input-/outputfield/accesses. The same goes if you want to delete an entry via sql. So i created a small sql to change the foreign key constraints on those tables to change from "ON DELTE NO ACTION" to "ON DELETE CASCADE"
I created them for PSQL but i think they will work for Oracle too. The only changes i found so far is that maybe on Oracle you need to put the "ADD CONSTRAINT ...;" in brackets -> "ADD (CONSTRAINT ...);"