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.

Related Commands:

FUNCTION - CREATE FUNCTION
FUNCTION - DROP FUNCTION

Related Views:

                                                         CODE_PIECES 
                                                         CODE_SIZE 
  DBA_SOURCE           ALL_SOURCE           USER_SOURCE 



Back to the Top

Simon Sheppard
SS64.com