Replacing part of an Oracle package

Question

I need to change one procedure from within the package. I need to relate to both declaration and implementation. Since I support patch files for each modification, I would like the changes to be minimal.

Is it possible to update a package only with a modified procedure (if so, how?) Or do I need to provide a complete definition and implementation of the package?

Answer 1

You need to replace the entire specification and body of the package - you cannot work only with part of the package.

Answer 2

Just to contradict everyone else.,

- -, , ( USER_SOURCE), EXECUTE IMMEDIATE.

, . , . - .

, - , . , . - , .

Answer 3

. , - CREATE OR REPLACE PACKAGE BODY.

Answer 4

, , . , , , ( ).

Answer 5

Oracle 11g , .