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

DBE_SQL_UTIL.show_sql_patch

show_sql_patch is an interface function used to display the SQL patch corresponding to a specified patch name and return 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 ID.

enabled

OUT bool

Specifies whether the patch takes effect.

abort

OUT bool

Specifies whether the patch is an abort hint.

hint_str

OUT text

Hint text.