DBE_SQL_UTIL.create_abort_sql_patch
create_abort_sql_patch creates abort SQL patches and returns whether the execution is successful. This function is an overloaded function of the original function. The value of parent_unique_sql_id can be used to limit the effective range of the abort patch.
Only the initial user, sysadmin, opradmin, and monadmin have the permission to invoke this interface.
Parameter |
Type |
Description |
---|---|---|
patch_name |
IN name |
Patch name. |
unique_sql_id |
IN bigint |
Global unique query ID. |
parent_unique_sql_id |
IN bigint |
Global unique ID of the outer SQL statement. The value 0 indicates that the SQL patch statement outside the stored procedure is restricted to take effect. A non-zero value indicates that the specific stored procedure is restricted to take effect. |
description |
IN text |
Patch description. The default value is NULL. |
enabled |
IN bool |
Specifies whether the patch takes effect. The default value is true. |
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.