Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Function Procedure Packages

 

Recompiling Packages

To recompile a package, use the ALTER PACKAGE command with the compile keyword. Recompiling a package recompiles all objects defined within the package. The following examples recompile just the body of a package. ALTER PACKAGE inventory_pkg compile body The following statement recompiles the entire package including the body and specification: ALTER PACKAGE inventory_pkg compile package