ALTER PACKAGE

Recompile a stored package.

Syntax:

   ALTER PACKAGE [schema.]package_name COMPILE [DEBUG] PACKAGE
   ALTER PACKAGE [schema.]package_name COMPILE [DEBUG] SPECIFICATION
   ALTER PACKAGE [schema.]package_name COMPILE [DEBUG] BODY

An alternative to ALTER PACKAGE COMPILE is the built-in pl/sql package DBMS_UTILITY

Using DBMS_UTILITY is the preferred method for Oracle 8.0 and above.

Related Commands:

CREATE PACKAGE
DROP PACKAGE

Related Views:

                                                         CODE_PIECES 
                                                         CODE_SIZE 
  DBA_SOURCE           ALL_SOURCE           USER_SOURCE