How to delete procedure or function from Package

Question

Suppose you create a package in Oracle 10g and has defined a procedure and a function inside the package. Now, How to delete a particular procedure or function in the package created, without physically DROPPING the package?? i.e. without using DROP PACKAGE package_name

I was wondering if i could actually perform the above action. Thank you in advance for any suggestions and solutions.

Answer 1

Since all objects in a package are stored as a unit, Oracle won't allow you to modify, drop or add packages or functions without replacing the whole package body.

You can find some discussion on the subject at the Oracle forums.