Borrar funciones

[Sherezade81]

Creo haberlo resuelto, mi parra, parrita:

CREATE OR REPLACE PROCEDURE BORRA_OBJETOS10 IS
CURSOR C1 IS SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE='FUNCTION' FOR UPDATE;
BEGIN
FOR REG IN C1 LOOP
EXECUTE IMMEDIATE 'DROP '|| REG.OBJECT_TYPE || ' "' || REG.OBJECT_NAME ||'" WHERE CURRENT OF C1';
END LOOP;
END;
/
Muchas gracias a todos!