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

execute DBMS_UTILITY.COMPILE_ALL;

Related Commands:

CREATE PACKAGE
DROP PACKAGE

Related Views:

                                                         CODE_PIECES 
                                                         CODE_SIZE 
  DBA_SOURCE           ALL_SOURCE           USER_SOURCE 




Back to the Top

Simon Sheppard
SS64.com