|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
ALTER CLUSTER to ALTER SYSTEM, 5 of 19
FUNCTION statement to recompile an invalid standalone stored function. Explicit recompilation eliminates the need for implicit run-time recompilation and prevents associated run-time compilation errors and performance overhead.
Note: This statement does not change the declaration or definition of an existing function. To redeclare or redefine a function, use the
The function must be in your own schema or you must have
PROCEDURE system privilege.
Specify the schema containing the function. If you omit
schema, Oracle assumes the function is in your own schema.
Specify the name of the function to be recompiled.
COMPILE to cause Oracle to recompile the function. The
COMPILE keyword is required. If Oracle does not compile the function successfully, you can see the associated compiler error messages with the SQL*Plus command
DEBUG to instruct the PL/SQL compiler to generate and store the code for use by the PL/SQL debugger.
To explicitly recompile the function
get_bal owned by the user
merriweather, issue the following statement:
If Oracle encounters no compilation errors while recompiling
get_bal becomes valid. Oracle can subsequently execute it without recompiling it at run time. If recompiling
get_bal results in compilation errors, Oracle returns an error, and
get_bal remains invalid.
Oracle also invalidates all objects that depend upon
get_bal. If you subsequently reference one of these objects without explicitly recompiling it first, Oracle recompiles it implicitly at run time.