Name

ALTER PACKAGE

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
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset