ALTER FUNCTION

Recompile a stand-alone function:

Syntax:

   ALTER FUNCTION [schema.]function COMPILE [DEBUG] [REUSE SETTINGS]

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

REUSE SETTINGS will prevent Oracle from dropping and reacquiring compiler switch settings. i.e preserve the existing settings and use them for the recompile.

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

"Any smoothly functioning technology will have the appearance of magic" ~ Arthur C. Clarke

Related Commands:

FUNCTION - CREATE FUNCTION
FUNCTION - DROP FUNCTION

Related Views:

 CODE_PIECES 
 CODE_SIZE 
 DBA_SOURCE     ALL_SOURCE     USER_SOURCE


© Copyright SS64.com 1999-2013
Some rights reserved