To recompile a procedure that is part of a package, recompile the entire package using the ALTERPACKAGE 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 CREATEPROCEDURE statement with the ORREPLACE clause (see CREATE PROCEDURE).

The ALTERPROCEDURE statement is quite similar to the ALTERFUNCTION statement. Refer to ALTER FUNCTION for more information.

Prerequisites

The procedure must be in your own schema or you must have ALTERANYPROCEDURE system privilege.