Purpose
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 OceanBase Database privileges, see Privilege types in MySQL mode.
Syntax
ALTER {procedure|function} name COMPILE [reuse settings]
Parameters
| Parameter | Description |
|---|---|
| procedure | Specifies that the alter type is procedure. |
| function | Specifies that the alter type is function. |
| name | The name of the specific stored procedure or function to be recompiled. |
| reuse settings | Optional. When the reuse settings clause is used, the compilation uses the same settings as the original PL object. If not used, the compilation is performed with the parameters set in the current session. |
Example
obclient> ALTER procedure test_p COMPILE reuse settings;
Query OK, 0 rows affected (0.242 sec)