ALTER FUNCTION

Recompile a stand-alone function:

Syntax:

   ALTER FUNCTION [schema.]function COMPILE [DEBUG]

DEBUG will instruct the compiler to generate and store the code for use by the PL/SQL debugger.

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

Related Commands:

FUNCTION - CREATE FUNCTION
FUNCTION - DROP FUNCTION

Related Views:

                                                         CODE_PIECES 
                                                         CODE_SIZE 
  DBA_SOURCE           ALL_SOURCE           USER_SOURCE