How do I recompile a set of PL/SQL packages?
Answer: The DBA will have to recompile a PL/SQL packages
whenever there are changes to tables, views, sequences, and so on that the
package procedures and functions reference. This is accomplished through the use
of the CREATE OR REPLACE PACKAGE [BODY] form of the CREATE PACKAGE command. The
format for the command is identical to that of the CREATE PACKAGE [BODY]
But be aware that all procedures, variables, and functions referenced in the
CREATE PACKAGE command must be present in the CREATE OR REPLACE PACKAGE BODY
command, for if you just use the command with a single procedure or function you
want altered, that will be the only object left in the body when you are
finished. Perhaps with a future release we will be able to use the package
definition as a link list, and this won?t be required. There is also an ALTER
PACKAGE BODY command that is used only to recompile the package body.
The format of the ALTER PACKAGE command follows.
ALTER PACKAGE [schema.]package_name
The DEBUG clause has been added to compile and store
debugging information for the specified area of the package for the PL/SQL
Also, see these related notes on re-compiling PL/SQL
packages and stored procedures: