ALTER PROCEDURE statement is used to explicitly recompile a standalone stored procedure. Explicit recompilation eliminates the need for implicit run-time recompilation and prevents associated run-time compilation errors and performance overhead.
To explicitly recompile a standalone stored procedure, use the following syntax:
procedure_name: The name of the procedure_name.
COMPILE to recompile the procedure.
EXECUTE and in PL/SQL block: