|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
ALTER CLUSTER to ALTER SEQUENCE, 12 of 18
PACKAGE statement to explicitly recompile a package specification, body, or both. Explicit recompilation eliminates the need for implicit run-time recompilation and prevents associated run-time compilation errors and performance overhead.
Because all objects in a package are stored as a unit, the
PACKAGE statement recompiles all package objects together. You cannot use the
PROCEDURE statement or
FUNCTION statement to recompile individually a procedure or function that is part of a package.
For you to modify a package, the package must be in your own schema or you must have
PROCEDURE system privilege.
Specify the schema containing the package. If you omit
schema, Oracle assumes the package is in your own schema.
Specify the name of the package to be recompiled.
You must specify
COMPILE to recompile the package specification or body. The
COMPILE keyword is required.
During recompilation, Oracle drops all persistent compiler switch settings, retrieves them again from the session, and stores them at the end of compilation. To avoid this process, specify the
If recompiling the package results in compilation errors, Oracle returns an error and the body remains invalid. You can see the associated compiler error messages with the SQL*Plus command
SPECIFICATION to recompile only the package specification, regardless of whether it is invalid. You might want to recompile a package specification to check for compilation errors after modifying the specification.
When you recompile a package specification, Oracle invalidates any local objects that depend on the specification, such as procedures that call procedures or functions in the package. The body of a package also depends on its specification. If you subsequently reference one of these dependent objects without first explicitly recompiling it, Oracle recompiles it implicitly at run time.
BODY to recompile only the package body regardless of whether it is invalid. You might want to recompile a package body after modifying it. Recompiling a package body does not invalidate objects that depend upon the package specification.
When you recompile a package body, Oracle first recompiles the objects on which the body depends, if any of those objects are invalid. If Oracle recompiles the body successfully, the body becomes valid.
PACKAGE to recompile both the package specification and the package body if one exists, regardless of whether they are invalid. This is the default. The recompilation of the package specification and body lead to the invalidation and recompilation as described above for
Oracle9i Database Concepts for information on how Oracle maintains dependencies among schema objects, including remote objects
DEBUG to instruct the PL/SQL compiler to generate and store the code for use by the PL/SQL debugger.
Oracle9i Supplied PL/SQL Packages and Types Reference for information on debugging packages
SETTINGS to prevent Oracle from dropping and reacquiring compiler switch settings. With this clause, Oracle preserves the existing settings and uses them for the recompilation.
If you specify both
SETTINGS, Oracle sets the persistently stored value of the
PLSQL_COMPILER_FLAGS parameter to
DEBUG. No other compiler switch values are changed.
PL/SQL User's Guide and Reference and Oracle9i Application Developer's Guide - Fundamentals for more information on the interaction of the
This statement explicitly recompiles the specification and body of the
accounting package in the schema
If Oracle encounters no compilation errors while recompiling the
accounting specification and body,
accounting becomes valid. Blair can subsequently call or reference all package objects declared in the specification of
accounting without run-time recompilation. If recompiling
accounting results in compilation errors, Oracle returns an error and
accounting remains invalid.
Oracle also invalidates all objects that depend upon
accounting. If you subsequently reference one of these objects without explicitly recompiling it first, Oracle recompiles it implicitly at run time.
To recompile the body of the
accounting package in the schema
blair, issue the following statement:
If Oracle encounters no compilation errors while recompiling the package body, the body becomes valid. Blair can subsequently call or reference all package objects declared in the specification of
accounting without run-time recompilation. If recompiling the body results in compilation errors, Oracle returns an error message and the body remains invalid.
Because this statement recompiles the body and not the specification of
accounting, Oracle does not invalidate dependent objects.