Oracle® Database SQL Language Reference 11g Release 2 (11.2) Part Number E17118-04 |
|
|
PDF · Mobi · ePub |
Functions are defined using PL/SQL. Therefore, this section provides some general information but refers to Oracle Database PL/SQL Language Reference for details of syntax and semantics.
Use the ALTER
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.
This statement does not change the declaration or definition of an existing function. To redeclare or redefine a function, use the CREATE
FUNCTION
statement with the OR
REPLACE
clause. See CREATE FUNCTION.
The function must be in your own schema or you must have ALTER
ANY
PROCEDURE
system privilege.
(function_compile_clause
: See Oracle Database PL/SQL Language Reference for the syntax of this clause.)
Specify the schema containing the function. If you omit schema
, then Oracle Database assumes the function is in your own schema.
Specify the name of the function to be recompiled.
See Oracle Database PL/SQL Language Reference for the syntax and semantics of this clause and for complete information on creating and compiling functions.