ALTER PROCEDURE

Recompile a stored stand-alone procedure.

Syntax:

   ALTER PROCEDURE [schema.]procedure_name COMPILE [DEBUG]

An alternative to ALTER PROCEDURE COMPILE is the built-in pl/sql package DBMS_UTILITY

Related Commands:

CREATE PROCEDURE
DROP PROCEDURE

Related Views:

                                                         CODE_PIECES 
                                                         CODE_SIZE 
  DBA_SOURCE           ALL_SOURCE           USER_SOURCE