DBE_SQL_UTIL.create_hint_sql_patch
create_hint_sql_patch creates hint 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 hint 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. |
| hint_string | IN text | Hint text. |
| 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.
