How to Delete Multiple Stored Procedures ?

pkrol · #1 (**permalink**) 01-05-04, 11:43

I would Like to delete all stored procedures from the database using sql statement, wild cards with DROP PROCEDURE , dont work
Thanks

andrewst · #2 (**permalink**) 01-05-04, 12:00

Quote:

Originally posted by pkrol
I would Like to delete all stored procedures from the database using sql statement, wild cards with DROP PROCEDURE , dont work
Thanks

Use PL/SQL:

Code:

BEGIN
  FOR r in (SELECT object_name FROM user_objects WHERE object_type = 'PROCEDURE' )
  LOOP
    EXECUTE IMMEDIATE 'DROP PROCEDURE '||r.object_name;
  END LOOP;
END;
/

Internet Services

Web Development

Digital Marketing

Consumer Tech