You are logged on to the database as a database user.
You are the owner of the database procedure or have DROPIN privilege for the schema to which the database procedure is assigned.
The database is in the ONLINE operational state.
SQL Reference Manual, DROP DBPROC[EDURE] Statement (drop_dbproc_statement)