DBE_SQL_UTIL.create_hint_sql_patch

create_hint_sql_patch is a function used to create SQL patches for hints. It returns whether the execution is successful, as described in Table 1. 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 call this API.

**Table 1** DBE_SQL_UTIL.create_hint_sql_patch input parameters and return values
Parameter	Type	Description
patch_name	IN name	Patch name.
unique_sql_id	IN bigint	Global unique 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.