Updated on 2024-05-07 GMT+08:00

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.
Table 1 DBE_SQL_UTIL.drop_sql_patch input parameters and return values

Parameter

Type

Description

patch_name

IN name

Patch name.

result

OUT bool

Specifies whether this operation is successful.