Synopsis
ALTER PACKAGE
[schema
.]package_name
COMPILE [PACKAGE | BODY]
Recompiles a stored package ( package_name). The
COMPILE keyword is required.
Keywords
- PACKAGE
Recompiles the package body and
specifications. This is the default.
- BODY
Recompiles only the package body.
Notes
This command recompiles all objects contained in the package. The
procedure must be in your schema or you must have the ALTER ANY
PROCEDURE privilege to issue this command.
Example
The following example explicitly recompiles the specification and
body of the reconcile package in schema scott:
ALTER PACKAGE scott.reconcile
COMPILE PACKAGE