CODEWITHSUNDEEP
oracle-databaseoracle10g
Rishu S
Rishu S

Reputation: 3968

How to delete procedure or function from Package

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.

Upvotes: 6

Views: 7965

Answers (1)

Joachim Isaksson
Joachim Isaksson

Reputation: 181027

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.

Upvotes: 7

Related Questions