DBE_SQL_UTIL.show_sql_patch

show_sql_patch is an interface function used to display the SQL PATCH corresponding to the specified patch_name and return the execution result.

Only the initial, sysadmin, opradmin, and monadmin users have the permission to invoke this interface.

Table 1 DBE_SQL_UTIL.show_sql_patch input parameters and return values

Parameter	Type	Description
patch_name	IN name	Specifies the patch name.
unique_sql_id	OUT bigint	Queries the global unique ID.
enabled	OUT bool	Determines whether the patch takes effect.
abort	OUT bool	Determines whether the value is AbortHint.
hint_str	OUT text	Specifies the hint text.