Looking for how to drop SQL stored procedure? A simple command as below in Oracle database will eventually remove the procedure from the schema.

You need to ensure you have the sufficient privilege to drop the procedure before proceed to the SQL query execution.

SQL> DROP procedure (schema_name.procedure_name);

In case of dropping procedure took a long time and hang, try to check for blocking for the ‘library cache pin’ in the Oracle database.

After you have kill the blocking session, you should be able to drop the procedure without any issue.

Refer to this post if you are having error in compiling Oracle Package.