DBE_SQL_UTIL.drop_sql_patch
drop_sql_patch deletes SQL patches from the connected CN and returns whether the execution is successful.
Only the initial user, sysadmin, opradmin, and monadmin have the permission to invoke this interface.
- SQL patches are not shared among CNs and need to be executed on each CN.
- If load balancing is enabled or a CN needs to be specified, you are advised to use the DBE_SQL_UTIL.drop_remote_sql_patch API to delete a CN.
| Parameter | Type | Description |
|---|---|---|
| patch_name | IN name | Patch name. |
| result | OUT bool | Specifies whether this operation is successful. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.