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 the privileges in OceanBase Database, see Privilege types in MySQL-compatible mode.
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 you specify the reuse settings clause, the parameters used to compile the PL object are the same as those used previously. If you do not specify this clause, the parameters set in the current session are used for compilation. |
Examples
obclient> ALTER procedure test_p COMPILE reuse settings;