|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
ALTER CLUSTER to ALTER SYSTEM, 12 of 19
PROCEDURE statement to explicitly recompile a stand-alone stored procedure. Explicit recompilation eliminates the need for implicit run-time recompilation and prevents associated run-time compilation errors and performance overhead.
To recompile a procedure that is part of a package, recompile the entire package using the
PACKAGE statement (see ALTER PACKAGE).
Note: This statement does not change the declaration or definition of an existing procedure. To redeclare or redefine a procedure, use the
PROCEDURE statement is quite similar to the
See Also: ALTER FUNCTION
The procedure must be in your own schema or you must have
PROCEDURE system privilege.
Specify the schema containing the procedure. If you omit
schema, Oracle assumes the procedure is in your own schema.
Specify the name of the procedure to be recompiled.
COMPILE to recompile the procedure. The
COMPILE keyword is required. Oracle recompiles the procedure regardless of whether it is valid or invalid.
DEBUG to instruct the PL/SQL compiler to generate and store the code for use by the PL/SQL debugger.
See Also: Oracle8i Application Developer's Guide - Fundamentals for information on debugging procedures
To explicitly recompile the procedure
close_acct owned by the user
henry, issue the following statement:
If Oracle encounters no compilation errors while recompiling
close_acct becomes valid. Oracle can subsequently execute it without recompiling it at run time. If recompiling
close_acct results in compilation errors, Oracle returns an error and
close_acct remains invalid.
Oracle also invalidates all dependent objects. These objects include any procedures, functions, and package bodies that call
close_acct. If you subsequently reference one of these objects without first explicitly recompiling it, Oracle recompiles it implicitly at run time.