ALTER COMPILE

Description

This statement triggers the recompilation of a procedure or function.

Privilege requirements

To execute the ALTER COMPILE statement, the current user must have the ALTER privilege. For more information about seekdb privileges, see seekdb privilege types.

Syntax

ALTER {procedure｜function} name COMPILE [reuse settings]

Parameters

Parameter	Description
procedure	Specifies that the alter operation is for a procedure.
function	Specifies that the alter operation is for a function.
name	The name of the stored procedure or function to be recompiled.
reuse settings	An optional parameter. If specified, the reuse settings clause is used to compile the procedure or function with the same settings as the original PL object. If not specified, the procedure or function is compiled with the settings from the current session.

Examples

ALTER procedure test_p COMPILE reuse settings;
Query OK, 0 rows affected (0.242 sec)