Purpose
This statement is used to trigger 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 AI Database privileges, see Permission classification.
Syntax
ALTER {procedure|function} name COMPILE [reuse settings]
Parameters
Parameters |
Description |
|---|---|
| procedure | Specifies that the type of alter is procedure. |
| function | Specifies that the type of alter is function. |
| name | The name of the specific stored procedure or function that needs to be recompiled. |
| reuse settings | Optional. When the reuse settings clause is used, the parameters are compiled using the same settings as the original PL object. When not used, the parameters set in the current session are used for compilation. |
Examples
obclient> ALTER procedure test_p COMPILE reuse settings;