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

DBE_SQL_UTIL.show_sql_patch

show_sql_patch displays the SQL patch corresponding to a specified patch name and returns the running result.

Only the initial user, sysadmin, opradmin, and monadmin 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

Patch name.

unique_sql_id

OUT bigint

Global unique query ID.

enabled

OUT bool

Determines whether the patch takes effect.

abort

OUT bool

Determines whether the value is AbortHint.

hint_str

OUT text

Hint text.