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 Oracle Commands:
FUNCTION - CREATE FUNCTION
FUNCTION - DROP FUNCTION
Related Views:
CODE_PIECES CODE_SIZE DBA_SOURCE ALL_SOURCE USER_SOURCE